I need the DDL...

bitbucket (9/8/2008)

---

Think when Lynn says:

she means what...

Still, I think this could be done without a cursor. From the logic in the code provided, I can't see any reason that requires a cursor. A set-based...

Could you provide the DDL for the tables (CREATE TABLE statements, if it is hugh just the key fields used in the query plus any indexed fields), some sample data...

Just a guess, but if I remember correctly that sounds like a permission error or the directory you are trying to access does not exist.

😎

Also, unless you have space constraints, I would not backup directly to a network share. Any network issues will cause your backup to fail. I'd backup to a...

Okay, one last try. I found another place that required a change. I also copied the generated sql to a seperate window in SSMS and checked the syntax,...

I found one more error when I rechecked my code. Try this:

declare @name nvarchar(200)

declare @month nvarchar(100)

declare @year nvarchar(100)

declare @filename nvarchar(900)

set @filename = N'D:\Data\'+@name+ '_Data.MDF'

set @month = month(convert(nvarchar(16),getdate(),112))

set @year =...

You had some issues with your single quotes ('). try the following code:

declare @name nvarchar(200)

declare @month nvarchar(100)

declare @year nvarchar(100)

declare @filename nvarchar(900)

set @filename = N'D:\Data\'+@name+ '_Data.MDF'

set @month = month(convert(nvarchar(16),getdate(),112))

set @year...

Basic response, it depends. You really need to look at the requirements of each database/application. It may make sense to have a mission critical database/application on its own...

I would also guess it depends on what you are doing inside the trigger as well. As I stated earlier, when I did write triggers (not that I don't...

Curious, what does the query in the sproc look like?

😎

If you have created the table for development, why drop and recreate it everytime? I'd change the create to truncate the existing table.

😎

Yes, changing the recovery model from full to simple will truncate the log allowing you to shrink the log. Immediately after shrinking the log, change recovery model back to...

icocks (9/5/2008)

---

A further thing to bear in mind - if there's an Insert trigger on the table, then it will be fired in response to option 2, but not option...