Do you want to capture for a particular period of time ?

niteshrajgopal (6/11/2010)

---

Hi ChiragNS.

Thanks for the advice. I've already had a case where the user had sql server installed and I didn't know the sa password. So I had to uninstall...

Hi

You can run the scripts from vb.net application itself. If you are creating database on sql server instance already installed in the users pc you need to get the username...

Hi

You can run the scripts from vb.net application itself. If you are creating database on sql server instance already installed in the users pc you need to get the username...

Sorry i missed that part in your original post. I have no idea about this.

Inside the proc you are checking if parameter value is less than 100 and setting it to 100 if the parameter is less than 100.

Take away that checking.

Hi

Can anyone explain this to me ? I have been away from SQL Server for some time... finding my way back. 🙂

Hi

My solution is based on the assumption that you have only a single "\" in your string. i.e. the variable will not contain a value like 'C\test\test". Note...

An iffy question IMHO. You need to make certain assumptions to come to the right/wrong answer.

Are the points being returned? 🙂

learnt something new.

I misread the question. Got the point only after looking at some posts :ermm:

I got an error. There is no script for table creation and data. How can we come to any conclusion.

Hi experts ... any ideas ?

why is'nt BIT treated like other datatypes?

Knew the right answer. Clicked on the wrong option by mistake. 😉