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
Separate names with a comma.