We have created local package under data transformation services
which will port data from one server to another server and we have
With the help of ALTER TABLE we can disable/Enable a trigger on a table.
But how can we find that the trigger is disabled/Enabled.
Binary data consists of hexadecimal numbers. For example, the decimal number 245 is hexadecimal F5. Binary data is stored using the binary, varbinary...
After adding the remote server with the statement
EXEC sp_addserver 'SERVERB', 'LOCAL'
U need to shutdown or restart the server once. Once...
If u are using a group by clause in the subquery then subqueries are preferred
in terms of performance otherwise a JOIN is sufficient.
By concatenating the both parameters we can get this.
select cls_id, id, name from prog
Ya, if it is 2k it will show with competency level info if the version
is sql 7 it will not show the info.
Yes satya i agree with u, in a couple of posts i have also mentioned
not to select data from system tables. However it is an info to see
What is the error u are getting while restoring the backup.
Sysdatabases will consists of Competency level. See sysdatabases topic
sql server books online.
Is there any anti virus software scheduled at
Server and also at client level.
If so schedule these jobs at late nights.
U can use distinct clause in select to eliminate duplicates.
Select distinct Numbers from tabnum
U can do like this.
First take backup of dbs in sql7 server.
copy the backup of sql7 dbs into the proposed 2k server
physically move the mdf and...
Why cant u try with varchar than char. If the data is fixed then let it be
In general we can see the error log becz it wont take that much time, Are
u using any dbcc traceflag commands to record the activity in logs.
What about the service pack level are u running with sp4 if not apply and
It will use only 2gb because of limitation and
In the server settings are u using dynamically configure sql memory or
use a fixed size memory if...
U can see cross-tab reports in Sql server books online for more info
which may helpfull.
U can use "" for this for ex as below
INSERT INTO EMP VALUES (2,"()RAMA")
INSERT INTO EMP VALUES (1,",RAMA")
INSERT INTO EMP VALUES (7,"%RAJA")...
Separate names with a comma.