You can use the below script to do the same. I've excluded system db's since the same can't be removed.

set nocount on

declare @dbname as varchar(80)

declare @server_name as varchar(20)

select @server_name =...

[font="Courier New"]Can you check whether SQLAgent service account has necessary permission on the share folder??[/font]

[font="Courier New"]I hope this details won't be stored in any of the systables.. Hope you need to run profiler or you can create some trigger to update user table for...

[font="Courier New"]Refer the link below for restoration of master category.. I hope this will help you!!!

How to Rebuild System Databases in SQL 2005[/font]

[font="Courier New"]Refer the below link also.

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=3240524&SiteID=1[/font]

[font="Courier New"]

jeevanr (4/23/2008)

---

Good Morning Everyone...

Due to some problems i have to change my database from MS Sql Server Express Edition 2005 to Ms Sql Server 2000? Can anyone help me...

[font="Courier New"]

pbyrum (4/21/2008)

---

Here is the error message:

Restore failed for Server 'pb003070\express'. (Micrsoft.SqlServer.Express.Smo)

System.Data.SQLClient.SQLError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetFor Creation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\lava...

[font="Courier New"]Hi,

Refer the below link...

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=3240524&SiteID=1

I hope this will help you!!![/font]

[font="Courier New"]Hi,

Welcome to sqlservercentral 🙂

Make sure SQLserver port is unblocked in firewall

Make sure to create correct alias in the client machine

If possible try connecting as SERVERNAME,Portno Eg.)mymachine,1433

If you are using...

You can make use of the below DMV's to find out which index is in use whether seek or user scan etc.

Sys.dm_db_index_physical_stats

Sys.dm_db_index_usage_stats

For DTA refer this article Database Tuning Advisor -...

[font="Courier New"]I hope SQLService account doesn't have privilege to the shared folder. Make sure SQLService account has necessary privilege to the shared folder and make sure sqlagent is running!![/font]

Commit depends on the checkpoint...

You can use the below query to take the varbinary output to a file.

Exec master.dbo.xp_cmdshell 'osql -E -S. -Q"select datei from person.address where addressid=1" -o"C:\test.doc" -ddatabasename'

[font="Courier New"]In SQL 2005 you can make use catalog views or DMV's for the same. You will get more information compared to sp_who2.. Users need view server state permission. Refer...

[font="Courier New"]Kumar,

I hope you can't get information of the user who has modified the job in systables. You can create a trigger to monitor the same, hence when ever the...