Hello,

Was your backup striped over two files?

If so, then take a look at this thread: http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic13519.aspx

Regards,

John Marsh

Hello,

I would not recommend changing a production DB to the Simple Recovery Model. If the DB is damaged between full DB backups, you can not recover from the Transaction Log...

Hello Carolyn,

I guess your script would only work for the default instance - wouldn’t it?

Regards,

John Marsh

Hello,

I believe you can get this information programmatically via WMI. Please see this article: http://www.databasejournal.com/features/mssql/article.php/3709441

It talks about changing the ServiceAccount property, but I guess you could just display...

Hello,

You can grant User "U2" permissions in the Schema "S1" as well as S2.

In SSMS Select the DB then Security, then Schemas, right click on the Schema and select Properties....

Hello,

Sorry, but I don’t really understand what your question is. Can you post your query?

Regards,

John Marsh

Hello,

What status does the SQL Windows Service have (in Computer Management)? Do you have any errors written to the Windows Event Log? What account does the SQL Service Run under?...

Hello Again,

sys.server_principals gives you the Server Logins and sys.database_principals gives you the DB Users in the selected DB.

Joining on the sid gives you the mapping (for one DB) e.g....

Hello,

The DB level Catalogue View sys.database_principals will give you details regarding DB Users (per DB). This can be jopined with the Server level (Login) information contained in sys.server_principals

Regards,

John Marsh

Hello,

It depends on how your data is being accessed. If all queries on the table go via Column1 and column3 or Column3 and Column5, then by combining the indexes you...

Hello,

Thanks for the script.

An interesting experiment, but unless there were hundreds of Views in a DB, I think I would prefer using a straight select e.g. Select * From INFORMATION_SCHEMA.VIEW_TABLE_USAGE...

Hello,

Just one minor amendment so that the script runs Okay on a case sensitive Server:

SELECT @crdate=crdate FROM sysdatabases WHERE name='tempdb'

Regards,

John Marsh

Hello,

You can set the Hidden property to True or False based on the result of an IIf expression.

Take a look at the following article that describes something similar (setting the...

Hello Again,

Thanks for posting the extra stuff.

The reason why I asked is, I like to try out the featured scripts, but like everyone else, I don’t have a lot of...

Hello,

If I understand correctly, you want to add a value in the total row (such as a group or table footer) that reflects the Average of that column - correct?

If...