Although my query is not exactly related to start/stop of SQL server, it involves stopping a SQL database within a server instance.

If I want to detach a database from an...

Thanks, it was exactly what you thought. because my user was a part of BUILTIN\Administrators group, he was given the sysadmin authority. After I...

I tried the settings as you have specified above. However, the user whom I am making a member of the datareader role, is still able to execute update statements on...

Sorry, but I could not understand what you meant. I am using SQL2000 MSDE. Could you please elaborate?

Thanks!

Thanks for the replies.

I too felt the same that, restricting "everybody" from manipulating the database is not possible. The next thing that came to my mind was encryption. However, by...

Hi,

The database was developed by me long time ago! It has an ODBC interface. So, I am looking at a tool which can be used against any ODBC/OLEDB source.

Krishnan

Although SUBSTRING would do the job, I am afraid till will slow down the performance a lot. My text data is > 8000 bytes, hence, if use SUBSTRING to get...

It does not tell me how to store the value returned from READTEXT into a variable. Could you please help there?

When I execute a query returning >100000 rows, then the virtual memory usage of sqlservr.exe (under Windows NT Task Manager) increases quite a lot (>200MB!!). Even after the querying application...

The BOL says that this flag when set to true closes the database when the last user disconnects. What I want is however different. I do not want the database...

quote:

---

There is a checksum and binary checksum function available with SQL Server. Checksums can be calculated on individual rows or for an...

I have not understood your solution fully. Can you please clarify me about what you mean when you say -

quote:

---

...I created...

quote:

---

How do you know how to filter the data being returned? ...

---

The time...

quote:

---

This interval field -- is it able to be of a unit smaller than the smallest time interval stored in the DB?...

quote:

---

Not simply. If you ran it through a middle ware component you could enforce it that way, or you could profile and...