achied

Hi , can anyone help me. I tried to start an SQL Server instance from command line with sqlservr.exe. But on the last line it said "a significant part of sql server process memory has been paged out. this may result in performance degradation". And my instance didn't start. But …

Insert into table t select ... From

[CODE] CREATE TABLE T { Name varchar(10) , Location varchar(10) , CONSTRAINT U_NameLocation UNIQUE (Name,Location) } [/CODE] use Unique constraint. Primary key column is unique too, but you can have more than one Unique constraint in one table

Ms. SQL Server treats constraint as an object. You can check it in sys.objects table.

Hi.. i have test it before, i was trying to transfer data from mysql to SQL.Sever. i was using MSDASQL Provider, it's an OLEDB provider for ODBC. 1.First of all, you have to install odbc driver for My.SQL. So you can access MySQL through ODBC provider. 2. After that you …

Is the that one error "do statement must have a while" ? You must close your do statement with while. Please check your again