Got me good.

and i thought there were no DMV's in 2012 for column index info.

Try reading these sqlservercentral links:

http://www.sqlservercentral.com/articles/Basics/xmlsimplified/1898/%5B/url%5D

http://www.sqlservercentral.com/articles/Basics/3117/%5B/url%5D

Do you have MultipleActiveResultSets=true?

It means you can execute multiple commands under the same connection.

I can't recall exact syntax but you have to use reader.close() or something similar.

lenrigby (6/16/2015)

---

Hi

I regularly have to run an SSIS package in SQL Server Agent 14 times, one for every year from 2002-2015 inclusive. This means I have periods of wasted time...

Leave it.

Check if you have "Verify Backup Integrity" enabled on your tlog backups.

1) Backup (Export) the registry.

2)Delete the following keys in regedit:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server (there should be multiple entries like Native Client, Redist)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

3)Go To and delete all the sub-keys referencing SQL Server...

Make sure SQL Agent account has Modify permissions.

Refer to this fix https://support.microsoft.com/en-us/kb/2803065:

There are other ways like Powershell or SQLCMD to accomplish this but this is the linked server way.

You have to create Linked Servers and add both servers participating in AO...

you can use:

exec xp_servicecontrol 'stop','SQLServerAgent'

GO

exec xp_servicecontrol 'start','SQLServerAgent'

GO

you don't need (select @@server) just use (@@server)

Here is the post describing multiple data files.

http://www.sqlservercentral.com/Forums/Topic1071180-146-1.aspx

You can use SqlCmd utility from command line:

sqlcmd -S yourservername -i sqlscript.sql

Resender (5/19/2015)

---

Ok following scenario

create table dbo.ADAssets

(Computername nvarchar(max))

insert into dbo.ADAssets

values

('AIRLBEOF3565 CNF:4e926e06-6f62-4864-aebd-6311543d',

'AIRLBEOF3565')

So if execute the following

select Computername

from dbo.ADAssets

where Computername like

'AIRLBEOF3565%'

I get both records,but if I do this

select *...