Hmm... What exactly did you do? Did you edit an existing template file or did you create a custom one?

Jared

Try double-clicking the user in the Security\Logins section of SSMS and then go to their status. Make sure this user has the proper permissions here.

Thanks,

Jared

See this link: http://msdn.microsoft.com/en-us/library/ms174169.aspx

Thanks,

Jared

Can I ask why you want to create this into a view vs a stored procedure?

Thanks,

Jared

This is probably the reason why. SQL Server Configuration Manager will allow you to change it and give the proper permissions to the...

Are you changing the account using SQL Server Configuration manager, or are you doing it from services.msc?

Thanks,

Jared

I would prefer to let the front end code get the current status then update it and insert a new row. However, SQL can do this for you if...

Also, I just found this link: http://weblogs.asp.net/rrobbins/archive/2009/01/15/ssis-package-user-variables.aspx It seems as though you CAN have more than 1 parameter, and that they will both be represented as ? until the...

Ok, I see what you are saying now. So, what if you pass the parameter as a comma delimited string or something similar, and then split it in your...

Check out this post: http://www.sqlservercentral.com/Forums/Topic948435-146-1.aspx

or this: http://auoracle.blogspot.com/2010/12/moving-full-text-folder-in-sql-server.html

Thanks,

Jared

I was under the assumption that you were just moving data and not removing other drives/partitions. Unfortunately, I am not familiar with clusters. However, of course if the paths...

I don't typically worry about the error logs... Are you keeping your transaction logs on a separate partition from your databases? Are you separating the system databases from the...

I would wait until your data becomes substantially larger. 50,000+ rows a day is substantial, but why set up partitioning until you get closer to that. You could partition...

If you say WHERE AutoId = ?, then SELECT AutoID AS WTTYP should yield the same results, yes?

Thanks,

Jared

To put it into the select, you just have to qualify it like SELECT 2, SELECT 'What I want to show up', SELECT @variableName

Maybe I am missing something?

Thanks,

Jared