Have a look at http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx

Regards,

Andras

Yep 🙂 (in this case, to script a db you can just compare it against an empty database,...

An alternative could be is to use a third party tool to script the whole schema, modify the creation script to include the right collation, create the new database, use...

rdimaria (1/15/2008)

---

I'm trying to get the script from "Tracking Illicit Users" to work on sql 2000. This code didn't return any results thogu I did not get the error.

Is...

Jeffery Williams (1/15/2008)

---

LOL Yeah I guess I did hijack

I figured while I had your ear I would avoid a whole new thread. Then again someone else may find the...

Jeffery Williams (1/15/2008)

---

🙂

Hey one more question for you if you don't mind.

I am writing an automated route that I do not want to run (will be scheduled as a job)...

This is similar to variables (these are pulled out of the script before execution, so a particular declaration is evaluated only once). Not sure how nice it is to use...

It is because of datatype precedence. Try casting the variables to varchars like:

SET @ObjectString = 'INSERT INTO SYS_Object

(MSGID, SQLID, ObjectName, ObjectTypeID, ModuleID, isActive, CreateDate, DBID)

SELECT ' + cast(@MSGID as varchar(100))...

On SQL Server 2000 you cannot insert the results of an exec into a table variable. (you can do this on 2005 and 2008 though). You could try to use...

Is this on SQL Server 2000 or 7? SQL Server 2005 should have instant file growth support.

Regards,

Andras

You can use the row_number function on SQL Server 2005 (I assume you are using this since this is the 2005 forum :))

SELECT *

FROM ( SELECT...

Gail is of course right :). If you just want to have an...

Hi, a very basic trigger you could use a starting point is:

CREATE TRIGGER dbo.view_badge_upd ON dbo.view_badge

INSTEAD OF UPDATE

AS

IF @@rowcount = 0

...

If you cannot use the same user to access the database, and want to be able to access it as dbo without prefixing the owner, you will need to change...

The column on which you are partitioning the data must be part of the table schema. You could denormalize your table if you must partition the dependent table. I assume...