Viewing 15 posts - 31 through 45 (of 57 total)
never used them myself so dont know how good they are but 2005 has logon triggers.
http://msdn.microsoft.com/en-us/library/bb326598(SQL.90).aspx
January 30, 2009 at 7:56 am
are the jobs sql agent jobs? if so, the details will be in msdb. otherwise you could add extra steps into the job which insert details into a...
January 30, 2009 at 3:29 am
for databases you could use
select * from sys.database_principals
January 30, 2009 at 2:11 am
you need to export data from oracle to a file? this is a good artice if you're using 10g.
http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
you may get a better response if you posted...
January 29, 2009 at 1:55 am
an SSIS package can be created to query the oracle database and insert the results into a sql server database. this package can be ran as a job during...
January 28, 2009 at 2:22 am
is it something like this you are after...
SELECT ......
FROM cwm_cust_upload
INNER JOIN cwm_cust
ON cwm_cust_upload.company = cwm_cust.ccmpny AND cwm_cust_upload.[customer number] = cwm_cust.ccust#
WHERE.....
January 28, 2009 at 2:01 am
problem might be that your @z is declared as an int yet you're trying to set it as a string. if @z is supposed to be a character string...
January 27, 2009 at 7:48 am
red gates sql compare is very good but it isnt free.
January 27, 2009 at 6:11 am
do you have a list of the 3000+ servers? you could create an SSIS package that connects to each server and runs a query which populates a table in...
January 27, 2009 at 3:18 am
not with sql server. you'll need to purchase 3rd party tools.
January 27, 2009 at 2:32 am
i'd guess that the answer is in the error message....
"You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database"
remove...
January 27, 2009 at 2:14 am
any transaction log backups need to be applied aswell. if there arent any then it should sync when mirroring is applied. you're primary database needs to be in...
January 8, 2009 at 7:06 am
are there indexs or triggers on the tables? you might need to change the name of them aswell?
December 12, 2008 at 9:07 am
the os name of the mdf, ndf or ldf file you want to move.
December 11, 2008 at 7:37 am
Viewing 15 posts - 31 through 45 (of 57 total)