Here is some code that may help, this will allow you to add 6 procs look at line 82 its where you can added your connection string also look at...

Hi,

I think it would be better for you to keep the cluster as a single node cluster rather than go with a standalone. This would be a lot easier all...

try

exec ('select * from db_name.table_name'' ) at TEST_LK

Why dont you change the test for a varible, when you read in the file that must have a file name like the database its been backed up from ie...

i second that this site is very good for learning.

http://www.w3schools.com/sql/default.asp

for a dba try

http://www.sqlcourse.com/intro.html

hope this helps also this site is very good 🙂

This was very useful and hope to use data warehousing in the future. Thanks again.

Terry

you can open enterprise manager and use query an or open sql server manager and new query or you can use osql or sqlcmd depending if you are using 2000...

I would stick to full backups for this as if you do god forbid have to recover it will make it much easier and also master is very small so...

did you try reading this

http://www.sqlservercentral.com/articles/Administering/unmarksuspect/137/

Terry

are you an administrator on the system concerned if not contact your server support team they should be able to assist with this and you really as a DBA should...

I would say just don't try the banks were all getting laid off 🙁

T

try this

dbcc opentran database

go

kill spid

go

alter database database set recovery simple

go

checkpoint

go

alter database database set recovery full

go

backup database pubs to disk = 'c:\database.bak' with init

go

dbcc shrinkfile (N'database_log' , 1)

go

ed is quite right however, I am guessing you are shrinking as you are running out of disk-space as that is the only reason I can think off. 2008 is...

if this is not a production db then maybe your best option will be to kill all the connections backup the db detach the database delete the tranlog manullay and...

The best step will be to ask your DBA if you can do some work with him, get some t-sql books.

Install SQL at home, practise on it, look at...