Viewing 15 posts - 12,646 through 12,660 (of 39,963 total)
chgn01 (4/12/2013)
from the link:http://msdn.microsoft.com/en-us/library/ms162560.aspx
That link is incorrect. Bug submitted to Connect: https://connect.microsoft.com/SQLServer/feedback/details/783547/implementing-endpoints-documentation-is-wrong
April 12, 2013 at 11:35 am
L' Eomot Inversé (4/12/2013)
It's...
April 12, 2013 at 11:34 am
Lynn Pettis (4/11/2013)
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.Dunno, but it really looks like he was dumped into getting this job done.
Yes,...
April 11, 2013 at 12:50 pm
L' Eomot Inversé (4/11/2013)
Jan Van der Eecken (4/11/2013)
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.
Dunno, but it really looks like he was dumped into getting this job...
April 11, 2013 at 12:48 pm
To expand, here's what I'd do:
Create table Logger
( myMessage nvarchar(max)
, DDLStatement nvarchar(max)
, UserName nvarchar(max)
, DatabaseName nvarchar(max)
, Timestamp datetime default (getdate())
)
;
Then I'd alter the trigger to insert data into...
April 11, 2013 at 12:01 pm
If you want to know if a sysadmin has enabled SA, I would ensure an audit is in place, with logging to a file. Set permissions for your sysadmin groups...
April 11, 2013 at 9:25 am
Interesting. Are you Win2K? Or does the article apply to other versions for you?
I need to save that bookmark. It's a handy article.
April 11, 2013 at 9:23 am
What Lynn said.
Documentation is you need it: http://msdn.microsoft.com/en-us/library/ms184325.aspx
April 10, 2013 at 3:48 pm
Powershell I've used:
$server = "dkrSQL2012"
$database = "AdventureWorks2008"
$query = "SELECT TOP 10 Document, FileName FROM Production.Document WHERE Document IS NOT NULL"
$dirPath = "C:\Users\Steve\Documents\Docs\"
$connection=new-object System.Data.SqlClient.SQLConnection
$connection.ConnectionString="Server={0};Database={1};Integrated Security=True" -f $server,$database
$command=new-object system.Data.SqlClient.SqlCommand($query,$connection)
$command.CommandTimeout=120
$connection.Open()
$reader = $command.ExecuteReader()
while...
April 10, 2013 at 3:47 pm
Have you looked at monitoring replication?
http://msdn.microsoft.com/en-us/library/ms151780(v=SQL.90).aspx
Are the 30k rows recent ones changed/added in the publisher? are you sure there is no filtering taking place for this article?
April 10, 2013 at 3:45 pm
You could use RG if you use a specific account/group for backups that you can fit into a classifier function. Read about that if you need to. This will potentially...
April 10, 2013 at 3:44 pm
Is there some reason you cannot attach this to another instance? If it's because of possible corruption, please make sure you copy the MDF before attempting.
If you have potential data...
April 10, 2013 at 3:41 pm
If Steven's link doesn't help you, post a sample XML document and some DDL. We can help you extract the data.
April 10, 2013 at 3:40 pm
In 2008, you should have queueing. DB MAil uses Service Broker under the covers, so I wouldn't worry about that.
http://msdn.microsoft.com/en-us/library/ms190307.aspx
I do think Sean could be right that you have a...
April 10, 2013 at 3:39 pm
SQLRNNR (4/8/2013)
Grant Fritchey (4/8/2013)
Any of the Threadizens going to be in Vegas for SQL Intersection this week?
I was down at the venue yesterday. I won't necessarily be at intersections....
April 8, 2013 at 12:24 pm
Viewing 15 posts - 12,646 through 12,660 (of 39,963 total)