As Paul mentioned, you could add this kind of business logic in a procedure, a trigger or even using udf functions as a constraint...but...

wouldn't that logic prevent any member from...

why so complex a logic for your PK? maybe I'm missing the reason because of the way you abstracted it to pseudocode.

why won't a plain old tried and true identity...

recovery time, as well as backup complexity play a big roll.

for example, to restore to a specific point in time, you need a FULL backup, and all the logs between...

Tara looks like no, can t drop...only with db_owner rights;

here's the code i tried, line by line, and it fails when i tried to dropt eh database as the test...

this is an important piece:

when you say

can you show us the SQL? is it a cursor going thru 45...

you need to make sure every part you concat together are cast as varchar(max); otherwise you hit an 8000 limit(or lower limit if your smallest var is smaller)

when you...

details, details, details.

your making it hard on us! you've posted over a hundred times, so I can pretty much assume you've seen requests to provide CREATE TABLE and INSERT INTO...

by using the CHARINDEX2 function below, which returns the nth position of a given string, this worked fine for me:

/*

Example:

SELECT dbo.CHARINDEX2('a', 'abbabba', 3)

returns the location of the third occurrence of...

good job on giving us the CREATE TABLE; you gave us sample data, but not in an easy-to-use format.

you'll see below, along with the INSERT INTO statements, we are able...

i'm guessing it's the wrong S?

@filename='\\VCDB02\j$\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\Step_11_xapi_backup.BAK'

should that be

@filename='"\\VCDB02\j$\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\Step_11_xapi_backup.BAK"'

note the path is wrapped in double quotes to allow file names with spaces?

as far as i know, if the path to the folder does not exist, the backup would fail.

if the path exists, the .BAK file would get created or overwritten...

don't do this in a trigger.

do it in a schedule job that occurs every X days, which would determine if the filegroup needs to be created yet or not....and if...

pink.thereisnoif (11/4/2009)

---

Hi All,

We have a database named 'Track' running on a 64 bit Sql Server 2005 enterprise edition.

Currently the Track DB occupies about 100G space, with 77G data, 16G index,...

not sure what you mean...inside a TSQL code block, you could use

print object_name(@@PROCID)

or do you mean show me all the sql statements that are currently running...

Bru Medishetty (11/3/2009)

---

So you mean,when some one updates the Customer Table column RepNum from 65 to 20 again it should update the counts in the Rep table and also like...