We have created local package under data transformation services which will port data from one server to another server and we have scheduled the...
Thanks bambola. Rushendra
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. Rushendra
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. Rushendra
By concatenating the both parameters we can get this. For example:- select cls_id, id, name from prog where (ltrim(rtrim(cls_id))+ltrim(rtrim(id)))...
Ya, if it is 2k it will show with competency level info if the version is sql 7 it will not show the info. Rushendra
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 the...
What is the error u are getting while restoring the backup. Rushendra
Sysdatabases will consists of Competency level. See sysdatabases topic sql server books online. Rushendra
Is there any anti virus software scheduled at Server and also at client level. If so schedule these jobs at late nights. Rushendra
Hi Rajendar, U can use distinct clause in select to eliminate duplicates. Select distinct Numbers from tabnum Rushendra
U can do like this. First take backup of dbs in sql7 server. copy the backup of sql7 dbs into the proposed 2k server 0r physically move the mdf and...
Why cant u try with varchar than char. If the data is fixed then let it be with char(20). Rushendra
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. one way...
What about the service pack level are u running with sp4 if not apply and see. Rushendra
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. Rushendra
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.
