In which case, check to see if there is an open transaction in the database; may be that someone has a transaction open that is locking the system tables.

If I've read that right, it sounds like the row count settings in your SSMS.

Go to "Tools" -> "Options"

In the new window, expand "Query Options" then "SQL Server" then "General"...

So you want to return the whole xml document in the row, if it contains the string anywhere in it, be it an element name, element value, element attribute etc?

If...

When you used a normal table, was this also created within your transaction? Or did it already exist and you simply populated it in your transaction and then performed...

I'm assuming that the file fails when this happens? In which case you can set up an error handler to inform you that it failed? Or am I missing...

Well, considering some of the transaction handling I've seen in the past, I could see why someone might get pernickety about them! But I think education is always a...

Well if you're going the bcp route with xp_cmdshell, you could consider using certificates; have a login mapped to that certificate and grant the execute privilege for xp_cmdshell to that...

Each method has advantages and disadvantages, depending on what you want to do.

Where I currently work, I inherited a system that was very heavily OPENROWSET based because it had allowed...

You can't directly transfer a primary key; you will need to drop it, then run the CREATE CLUSTERED INDEX statement with the DROP_EXISTING = ON clause and specify the new...

This isn't true, you can shrink a transaction log file that is in a log shipping configuration without affecting the log shipping.

However, I'd only do it if the log has...

I'm not sure what good having them restored as user databases does, unless I'm missing something?

All my databases, including system, are backed up regularly and stored in several secure locations...

I believe it is set up as part of policy based management; it will call sp_syspolicy_purge to remove the policy evaluation history based on the HistoryRetentionInDays setting.

http://msdn.microsoft.com/en-us/library/dd795279.aspx

Not especially elegant, but this should work:-

DECLARE @datestring char(9)

SET @Datestring = '1130531'

SELECT SUBSTRING(@datestring, 4, 2) AS MonthPart

, SUBSTRING(@dateString, 6,2) AS DayPart

, CASE WHEN LEFT(@datestring, 1) = 0 THEN '19' ELSE...

Yes. The login by default is a member of the public server role, which by default is granted the VIEW ANY DATABASE server permission.

If you don't want this to...

SELECT DATEPART(weekday,DATEADD(mm, 3, '2013'))

This will return the day of the week, where 1 = Sunday, 2 = Monday etc.

Bear in mind that if you are only passing in the year...