atramard (12/1/2009)

---

Ie you get a Disk out of space allert what can you do to sort the server out once youve:

- shrink any file you can

- move DB's...

I'm guessing that you haven't...

How did you try the import?

There are several Access-SQL 'upsize wizards' on the MS site. Have you tried those?

RCC-JAXDBA (11/30/2009)

---

Also, be careful of truncating log files (backup log XXX with truncate_only) in a production environment if you are running tran log backups as this will interrupt the log...

Do not delete the transaction log unless you're comfortable with the chance of getting a suspect and unusable database afterwards.

Anyone feel like tackling this? I do not have the free time today to give it the attention it looks like it needs

http://www.sqlservercentral.com/Forums/Topic826285-1291-1.aspx

Sherri Barkley (11/30/2009)

---

So I think I am going to have the server guys take a look at the server and make sure it isn't a hardware issue before I try...

The best fix for this is to restore from backup. Don't try and restore then DTS stuff around. The system tables are not to be messed around with in that...

Because inserted is only visible in the trigger itself, not in...

Sample data and expected results please. Also, the definition of the cursor (and whatever table it's based on).

As it is, I can't test on my own machine and get you...

Not sure how knowing VB or C# will help in troubleshooting SQL.

So this is for SSIS, not SQL itself? If so, I'll ask the mod to move the thread...

You mean to write front-end apps to interface with SQL?

If you're not familiar with the language I'd suggest a good 'beginner's guide to..' type book.

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

It is joined, just the ON clauses are missing

DELETE FROM a -- table to be deleted from

FROM ATable...

A delete can only affect a single table. It will affect the table that's specified straight after the DELETE [FROM]. Any tables after the second FROM are just used to...