Scenerio:

I need you to apply SQL Server hotfix KBxxxxxx to my database and it requires the services restarted. Please do this at 1 PM as that is our business downtime...

WHy? Why aren't you just using the Maintenance Plan in SSMS? That is why it's there.

-SQLBill

Something happened at this step:

DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;

It transformed or copied the first 5000 records and then failed. Something may have been wrong with the...

If you have SQL Server security auditting enabled, you can check the error log to see who was logged in at that time. But SQL Server doesn't keep track of...

Check out XCOPY at this link...

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/ntcmds.mspx?mfr=true

That will give you a start with how to copy the file(s) using a command line.

-SQLBill

You might be able to retrieve the latest file number using RESTORE FILELISTONLY command. Put that into a variable and use it in the restore command. I've never tried...

I always use the auto_fix and it works for me.

sp_change_users_login 'auto_fix', 'user'slogin'

-SQLBill

If I understand you correctly, something like this:

INSERT INTO \\testsvr.dbname.dbo.main_table

SELECT TOP 10 *

FROM main_table

INSERT INTO

\\testsvr.dbname.dbo.second_table

SELECT *

FROM second_table

WHERE second_table.id IN (SELECT main_table.id FROM \\testsvr.dbname.dbo.main_table)

Something like that?

One other option is to...

Truncating the tlog depends on the Recovery Mode being used.

Full Recovery Mode: A full backup will not cause the tlog to truncate. The tlog will only truncate when a log...

Also, be careful of these types of errors in your code:

e.Assessed_Value,

From APPN_School_List a,

Notice you have a comma after the last column and before the FROM. That will return a syntax...

Best,

Usually people who are wanting answers to homework, supply the question and have done no work on their own. They want us to do all the work.

You must have done...

Can you post a sample of what it is returning?

-SQLBill

And once you've worked with the BOL and want to advance even more, check out Ken Henderson's Guru's Guide to Transact SQL.

-SQLBill

Yes, but when you restore the Database you are restoring both the data and the log files. You need to tell it then where the log file will go. ...

None that I know of. Just create a job that cycles the log. Try cycling it once a month. If that's not enough, do once a week.

-SQLBill