Thank you!

try this command in tsql / query analyzer

backup log MyDatabaseName with truncate_only

although, if this was a tempdb then the story might be a different one..

let me know..

John Esraelo

"You can execute operating system commands with SQLCMD Mode. Take care not to execute statements that prompt for a response. It is not possible to interact with the connection to...

Adam, you are absolutely right.

I will have to either keep the 2000 for my business sake or change my iBuySpy Store {shopping cart app} to work with the 2005.

I have...

Danny, I was hoping that would work, here is what I did during the last 40 minutes.

1> backed up and restored the 2000 in 2005 {no go}

2> detached 2000...

the restore option of 2000 in 2005 sounds real simple; however, the stored procedures in this database use dtproperties and sysusers, etc.. would those tables also get crossed over or...

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600:...

While having the logfiles compile and accumulate the important information in the logs about the database server activities; I would say it would be a very good idea to have...

Did your authoring tool / editor, or perhaps copy&paste remove all the indentation?

If not I strongly recommend you keeping the code easy to read.

Just a thought.

John Esraelo

I had no idea that it was a bad idea either..

hmm, I would really like to know that too.

thx

John Esraelo

are you referring to this method or something in that nature (see below):

---

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is...

wow, I got to try that...

This way, I don't have to worry what's being added or not, I will just call them all in...

thx

John Esraelo

Check your "task manager", sort the processes alpha, look for iExplore and you will see the multiple node of that running in the background.

So, one of the responses to your...

Hi,

Where this statement is being invoked from?

Meaning, are you in query analyzer or this statement is part of a function/sp?

John Esraelo

Alright, so, since I am not as good as you are in that area, I will have to read your posting couple of more times in different speeds +...