As jan van asked why are you using nvarchar

You must have noticed that in your result some numbers are missing . This is actually charactor comparison.

If you want the correct...

Great article. Very useful for DBA in production environment.

Thank you for the wonderful article.

Looking forward to hear more on performance

Conceptually both are same.

Login lets you connects to the server

and User has the permissions inside the database.

Only difference is in 2000 the user and schema are clubbed.

In 2005 they are...

Thanx Sturner

Pls use add topic link below

SELECT o.Name as TableName,

i.rowcnt Row_count,

c.Name as ColumnName,

t.name as DataType,

t.length as [DataLength],

c.collation

FROM sysobjects o

JOIN syscolumns c

ON o.id = c.id

JOIN systypes t

ON c.xtype = t.xtype

JOIN Sysindexes i

ON o.id=i.id

WHERE o.xtype = 'u'

and i.indid...

You can add a join to sysindexes and filter for clustered index or heap (indid in (0,1)

You can check the restorehistory in msdb database to conform the restore. View logs for the jobs

Hi,

How did you set up the log shipping , manually or wizard. Was the log applied on the secondary? what frequency is configured for the log to ship.

Graphic designer->Video editor-> then website developer->

.net developer

(all the above without much luck)

Finally SQL DBA for past 4 years. Happy everafter

It is possible for different nodes be patched differently.

Just see why you have that much unallocated space in files. Normally this much free space comes after some cleanups only (if it is data file). If it is not...

No

You can use xp_cmdshell.

xp_cmdshell 'sc qc mssqlserver'

Note: xp_cmdshell makes your server vurnerable to threats. Disable it once you are done