Can you tell me how to set up a transaction log backup for every 15 mins?

Actually I changed the file growth to 5%. Looks like it is working fine.

The log file size is 9GB.

Can any suggest any steps to avoid the same thing happening...

There is more than 30GB of free space. Anyone?

I tried to execute a simple user login stored procedure from the query analyzer, it took for ever to complete the execution. It did not complete the execution after 5...

I am using sql server authentication. The credentials work if I terminal-in into the sql server machine. But if I open the client utility enterprise manager from my desktop, everything...

"If you pass 1 & 3, do you want to return customers who subscribe ONLY to 1 & 3, or customers who subscribe to AT LEAST 1 & 3 and...

Well, the result should contain customers who have subscribed for both 1 and 3. If we use IN, won't the result cotains customers who have subscribed for either 1 or...

This is a stored procedure. I join two tables, there is no views. I construct a sql stmnt based on the search parameters. The sql goes something like this,

"SELECT ...list......

No, it happens at different times. I am checking the page once in a while, but I did not get any errors so far.

This is the error message.

Error Message:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Stack Trace:

at...

Thanks guys.

Can you please explain how applocks table method works. Or any pointer to online article or tutorial will be helpful.

Thanks.

Thanks Ray. That's what I was thinking of doing. But wanted to know if there is any straight-forward way to do it, I guess not.

Hi,

You said 'Handle encryption/decryption client-side'. You mean using javascript? Can you please explain on how to do this?

Thanks.

Thanks Ray.