Viewing 15 posts - 106 through 120 (of 286 total)
Jeff Moden (9/30/2010)
SQL_Quest-825434 (9/24/2010)
sqlapprentice (9/24/2010)
sjimmo (9/24/2010)
The problem lies in that fact that xp_cmdshell does not recoginize lang windows paths but we can still use shortend path names with tilde (~)...
October 1, 2010 at 8:45 am
Jeff Moden (9/30/2010)
SQL_Quest-825434 (9/24/2010)
sqlapprentice (9/24/2010)
sjimmo (9/24/2010)
The problem lies in that fact that xp_cmdshell does not recoginize lang windows paths but we can still use shortend path names with tilde (~)...
October 1, 2010 at 8:45 am
sqlapprentice (9/24/2010)
sjimmo (9/24/2010)
The problem lies in that fact that xp_cmdshell does not recoginize lang windows paths but we can still use shortend path names with tilde (~) in them.
This is...
September 24, 2010 at 8:45 am
Hello,
when I use this:
declare @sql varchar(max)
set @sql = '"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\BCP.exe" "SELECT top (1) [Deadlockgraph].query(''/TextData/deadlock-list'') FROM dbname.dbo.tablename" queryout d:\xmlfile.xdl -T -c -q'
exec master..xp_cmdshell @sql
this is the error:
Msg 214,...
September 21, 2010 at 7:43 am
gmamata7 (9/20/2010)
I would like to have a script to monitor blocking. The script should run every 2 mins and if it finds the blocking, it should send an email to...
September 20, 2010 at 7:31 pm
GilaMonster (9/20/2010)
AndrewSQLDBA (9/20/2010)
I was experiencing the chain being broken when a full backup was taken.Andrew, there's something else happening that's breaking the log chain, because full backups do not.
Perfect...
September 20, 2010 at 3:18 pm
GilaMonster (9/20/2010)
Full backups do not truncate the transaction log. They do not break log shipping.
Hello Gail,
I cannot understand this "They do not break log shipping" as I am...
September 20, 2010 at 2:44 pm
AndrewSQLDBA (9/20/2010)
I am performing log shipping between two boxes. But I have had to write the code for the secondary box because the secondary box is in a DMZ....
September 20, 2010 at 2:40 pm
Hello,
This might be useful http://duartes.org/gustavo/blog/post/lock-down-sql-server-2005
HTH,
Cheers !
September 6, 2010 at 8:16 am
It can be done via a registry setting and, yes, that CAN be done via undocumented T-SQL sprocs
Jeff,
Can you quote the how this can be done.. just curious to...
September 6, 2010 at 7:53 am
Is there any reason of using Variables and not using Temp tables ?
September 1, 2010 at 7:21 am
SqlServerLover (8/21/2010)
August 22, 2010 at 7:13 am
twebster-856509 (8/22/2010)
i am at loss, im getting the following error message on one of our SQL Servers sitting on a clustered SQL environment, this error has only started...
August 22, 2010 at 7:06 am
just to add 50 Cents more to what george mentioned:
The restore would fail if it is not given exclusive access.
Add this before your restore:
alter database db_name_to_restore
set single_user with rollback immediate
waitfor...
August 19, 2010 at 7:52 pm
Viewing 15 posts - 106 through 120 (of 286 total)