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...

Also, MERGE isn't available in SQL Server 2005, and our LOB systems will not migrate to SQL Server 2008 until the vendors support SQL Server 2008. We just now...

I agree with Grant.

😎

Are you using SQL Servers BACKUP and RESTORE? You may want to consider purchasing a third-party backup solution that will allow you to compress your backups files during the...

You're 1/3 of the way there. Still need sample data and expected results based on the sample data.

We can at least start looking at the query, but we need...