Try this

declare @dbname varchar(10)

declare @sqlstr as nvarchar(500)

set @dbname = 'master'

set @sqlstr = 'select * from ' + @dbname + '.dbo.sysfiles'

exec sp_executesql @sqlstr

Hope this helps

This might help

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp

Depends on what you are wanting to do. If this is for a drp solution I suggest you look at using log shipping. If it for reporting  then perhaps you...

Good article but I have to agree with most of the folks out there

backup and restore is the way to go.

By the way how do you attach a database with...

Go to startup parameters dialog box in enterprise manager

change the default location for the errorlog to the new location

the existing parameter will start with -e

restart sql server ( out of...

Need more info. are you attempting a database backup or exporting the data to a file such as excel or csv?

What service pack is your sql server?

Had this problem a long time ago on sp2. Upgraded to

sp3a has since gone away.

By the way if your after a great smtp...

It sounds like this database is using transactional replication.

Check and make sure that this process is running sucessfully by the sounds of thinks

it's not. You might want to find...

Fantastic article. The great thing about being human we make mistakes and then we learn from them. 

Be nice if there was an undo command or button in SQL server 🙂

Smart and simple.

I also find using sysjobs_view useful in place of sysjobs. Especially if you are managing more than one server.

The extra colum originating_Server can tell which server the job...

Great article and a great product. I have been using this product for a couple of years now and it has saved us plenty!!

Great interview. In particular the comments on the Quest purchase of Imceda. Lets hope it doesn't go that way. Part of reason it's a great product is the support. Hate...

I found this kb article on using the IF update(column name)

http://support.microsoft.com/kb/64238/EN-US/

Try this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

Thanks Steve.

I have  dbcc inputbuffer and fn_get_sql () on the brain!

 I meant dbcc indexdefrag