Search Results

Search found 87891 results on 3516 pages for 'server migration'.

Page 307/3516 | < Previous Page | 303 304 305 306 307 308 309 310 311 312 313 314  | Next Page >

• Crystal Reports vs. Microsoft SQL Server Reporting Services

  - by DATT OZA

  I am developing a WPF application, and I need your advice. I have to generate reports in my application. What should I use, Crystal Reports or SQL Server Reporting Services? Which one is better, and why?

  Read the article

• Using triggers to update linked server table

  - by tabouakl

  Can I use triggers to insert or update tables in a linked server? I tried it and got the following error: Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF. [OLE/DB provider returned message: Cannot start more transactions on this session.] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction returned 0x8004d013: ISOLEVEL=4096].

  Read the article

• sql server 2005 databse password recovery

  - by air

  i have one database in ms sql server 2005. i create this long time back, now want to modify it but i lost the password, i remember the user name for that database, is there any way to recover the password for that database or change its password ? Thanks

  Read the article

• javascript library for client side storage with server side sync

  - by user126861

  I'm looking for a javascript library that will let me store data in a client side database and in the back ground automatically sync the database back to the server's database preferable something that supports a variaty of engines in the same way jStore for jQuery does Looking around I can find anything

  Read the article

• VS2010 ultimate DataBase Project + SQL Server 2008: Updating Project from Database

  - by josecortesp

  Hello everyone, this is a quick question: I have this Database Project in a Web app solution with the real database. I want to update the database using SQL server managment studio, and then update the corresponding VS project. This can be done? I know that you can update the scripts in the project, but I'm not the SQL kind of guy, i rather do this changes using Mangment studio... Thanks in advance

  Read the article

• Cocoa Touch & Sql Server

  - by kim3er

  Is it possible to connect to Sql Server for the purpose of executing simple Sql commands within a native iPhone app? If so, how does one go about it? I'm stumped. More generally, I would at least like to see how this is done with GCC. Thanks in advance, Rich

  Read the article

• Resources for high performance SQL Server database design

  - by Nathan Ridley

  I'd like some suggestions for online resources (blogs, guides, etc - not forums) to help me become good at designing high performance SQL Server databases that operate with large amounts of data and have heavy loads in terms of data turnover and queries per minute. Suggestions?

  Read the article

• TSQL to grant db_datareader and db_datawriter for MS SQL Server

  - by consultutah

  What is the exact SQL to assign db_datareader and db_datawriter roles to a user in SQL Server? Say the user name is MYUSER and the DB in question is MYDB. Thanks!

  Read the article

• Sub-Schemas in SQL Server 2005/2008

  - by Maushu

  This is a simple question yet I was unable to find any information at all about this. Is it possible to have sub-schemas in SQL Server 2005/2008? Example: Having a HR (Human Resources) schema with a sub-schema called Training (with tables related to this). It would end up like HR.Training.* where * would be the tables.

  Read the article

• SQL Server 2008 Spatial Clustering

  - by illvm

  I am trying to group points of geospatial data based on density and relative distance. Is there a way that this can be done in SQL Server 2008 using the spatial features or would it be better to translate the data into graph data and use a graph clustering algorithm?

  Read the article

• Shrink Sql Server database

  - by hani

  My SQL Server 2008 database file (.mdf) file is nearly 24 MB but the log file grown upto 15 GB. If I want to shrink database what are the important points to take into consideration? Will shrink causes any index fragmentation and does it affect my database performance?

  Read the article

• SQL Server 2008 Reporting Service 2008 the page margins not set while exporting to Excel

  - by BIPIN

  Hi, While using new SQL Server 2008 Reporting Service 2008 the page margins that I specify in Report Properties Page Setup do not seem to flow through to Excel when exported? They always seem to be set to Top & Bottom: 2.5cm, Left & Right: 1.9cm, no matter what I set them to in the report. This was working perfect in 2005 version. Any help would be much appreciated. Thanks, Bipin

  Read the article

• joining null in MS SQL server, Oracle and informatica

  - by jest

  hi! I've two tables to join with a column(say emp_id)..if emp_id in both the tables have null values, how'll MS SQL server and Oracle treat??? Coz, i read that informatica will neglect the NULL rows when joining..if i handle the null, by substituting -1, a cross-join will happen which i don't want.. what can i do here? I cannot completely neglect the rows which has NULL. Thanks

  Read the article

• Wingding chars in sql server 2005

  - by Savvas Sopiadis

  Hi everybody! In a winforms application i 'm storing one Wingdings char in a SQL Server 2005 field of type NVARCHAR(1). Storing, retrieving and showing up this char in a control works fine. The problem i'm facing is this: how to search for records which have a specific wingding char value: for example Select * from table where FieldWithWingding = valueOfLeftArrowChar How to achieve this? Thanks in advance

  Read the article

• iPhone HTTP Server

  - by Andrew

  Can someone give me simple code to help with creating an HTTP server for the iPhone. Something simple with much documentation would be appreciated. Anything you have please share.

  Read the article

• SQL Server online backup with MozyPro

  - by Erick Sasse

  Anyone using MozyPro to backup SQL Server databases? I'm concerned about the way it does the backup. It just copies data files the way they are. Not using the backup database command. Is it safe?

  Read the article

• how to access subversion server remotely

  - by George Mic

  I just installed VisualSVN server yesterday at my home computer and I can access my repositories ok at localhost but when I try to access it remotely, it won't connect. Am I supposed to configure something else or is it not possible? I'm using https://servername/svn as the URL in my browser and the home computer is behind a router. This is only for personal use. Thanks

  Read the article

• Print DataBase Schema in Sql Server Compact Edition

  - by hosseinsinohe

  Hi All I Want Print DataBase Schema in "Microsoft Sql Server Compact Edition". Maybe Exist Some Tools For it. How Can I do it?

  Read the article

• MS-Access to SQL Server 2000 problem with datetime

  - by 0plus1

  I'm trying to transfer some data from Access to SQL Server 2000 (there are no other way to do this sadly), I'm using Access to mssql to do the job. The program fails everytime it finds a datetime in this fashion: 03/07/2009 10.17.00 While it imports date like this: 29/12/2008 I don't understand where this problem come from so I ask you for your help. Thank you very much.

  Read the article

• Undo table updates in SQL Server 2008

  - by sikas

  I updated a table in my MS SQL Server 2008 by accident, I was updating a table from another by copying cell by cell, but I have overwritten the original table. Is there a way that I can restore my table contents as it was?

  Read the article

• SQL Server cast fails with arithmetic overflow

  - by Jamie Ide

  According to the entry for decimal and numeric data types in SQL Server 2008 Books Online, precision is: p (precision) The maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision of 38. The default precision is 18. However, the second select below fails with "Arithmetic overflow error converting int to data type numeric." SELECT CAST(123456789 as decimal(9,0)) SELECT CAST(123456789 as decimal(9,1))

  Read the article

• Windows Server 2008 on VPC (Host: Win 7)?

  - by Dan

  Is it possible to test Windows 2008 server via VPC when my host of a Windows 7 machine? I don't see anywhere where it says this is possible? The only VPC images (Windows 2008 R2) that I download from Microsoft state that the host machine must be Windows 2008. Is there an alternative?

  Read the article

• the coding problem in server

  - by zahir hussain

  $fp = fopen("http://feeds.reuters.com/Reuters/PoliticsNews?format=xml","r") or die("Error reading RSS data."); The above coding working correctly in localhost;;; but in server display "Error reading RSS data."... i dont know why.... anybody please explain me... i am waiting... thanks

  Read the article

• Python port forwarding/multiplexing server

  - by Ib33X

  I would like to make server that listen on UDP port 162 (SNMP trap) and then forwards this traffic to multiple clients. Also important is that the source port & address stays same (address spoofing). I guess that best tool for this would be Twisted or Scapy or mybe vanilla sockets, only I can't find anything in the documentation for Twisted about source address spoofing/forging. What would you recommend me to do? Edit:added bounty

  Read the article

• Stored procedure sometimes returns empty result in SQL Server 2008

  - by Nezdet

  I upgraded recently from SQL Server 2005 to 2008 and I have some problems. First of all, if I press the search button it returns results, and the next time I press the search button I get an empty result. What's wrong, and why is it doing that?

  Read the article

< Previous Page | 303 304 305 306 307 308 309 310 311 312 313 314  | Next Page >