have a look at Books Online ( highlight your "convert" keyword and hit Shift+F1 if your query pane )

That will open your local copy of books online and show info...

KP-249943 (11/5/2009)

---

Hi,

We have a SQL Server 2005 (SP3), Enterprise (64 bit) edition.

The data is on the H:\ drive. The Transaction Log is on the F:\ drive. Both H:\ drive and...

also have a look at the demistifying article Gail Shaw posted http://www.sqlservercentral.com/articles/64582/

scheney-1152259 (11/5/2009)

---

Hi there,

From what I've seen this question gets asked quite a bit, but I can't get a solution that works for me.

I am running a database using SQL Server...

Currently SQL2005 is on SP3 for a while now ! You should evaluate it and upgrade if you can !

The logon trigger (available with sp2) is only validated...

Tara-1044200 (11/4/2009)

---

I have database with 100's of partitions ( a partition for a month) , how can i add or delete partitions on 2TB database.

example:2TB of databases containing 20 yrs...

If you have SQL2005 SP2 or higher have a look at http://www.simple-talk.com/sql/sql-server-2005/logon-triggers/

- please post in the correct forum ! ( this is a sql2005 forum )

- the lack of SQLAgent manager role is one of the weak spots of SQL2000 ...

HTH

Keep in mind that if you are using sqlauthentication and didn't migrate the sqluserid including the SID, you must resync the user ids using:

-- to be executed per sqluserid !

exec...

What issue did you encounter to validate the need to uninstall the sp ?

Robert Frasca (10/30/2009)

---

Just to clarify. If you're using 64-bit SQL Server it is recommend that Lock Pages in Memory be enabled and that the AWE enabled switch be set....

it isn't mandatory, but it helps for sure :-P:-D

I posted my SQL2005 script, because you posted in the SQL2005 forum !

for sql2000 you can use:

SET NOCOUNT ON

SET ROWCOUNT 1000

WHILE 1 = 1

BEGIN

DELETE TableName WHERE <Your Condition Here>

...

You can also produce the backup to a remote location, provided you grant...

That's an eye opener indeed !

In many cases we only see the beauty of life, once we have to mis part of it.

For Belgium these links may get donation started:

Flemish...