The Visual Studio components that are installed with SQL Server do not require any additional licensing outside of the SQL Server licensing itself.

If you are looking for something that is free you can download SQL Server Express Edition.

http://www.microsoft.com/express/Database/

Although if you are really wanting to learn SQL Server I would suggest...

Jack beat me to it. 🙂

You will want to use the OVER clause and PARTITION BY argument with the ROWNUMBER() function that Jack suggested to achieve your desired outcome. Check out this MSDN link...

That is definitely correct, the guest account would have to be granted permissions in the second database for that to work. I suppose you could use a logon trigger...

Have you thought about using an application role to facilitate this?

http://msdn.microsoft.com/en-us/library/ms190998.aspx

Thanks for the details. Greatly appreciated!

I have implemented something very similar to this however; instead of creating the PackageLogID as a user variable I am just using the system variable "ExecutionInstanceGUID". I am curious...

In addition to what Greg mentioned above you can also set the column to not allow nulls in the designer. I am not sure it is completely necessary but...

GilaMonster (5/5/2009)

---

How full is the transaction log? If there's 90GB of log data in there, it won't shrink below that.

Use DBCC SQLPERF(LogSpace) to see what percentage of the log is...

Thanks Adam, I'm not trying to be pushy I have just had good luck with that procedure. Hope it works! Let me know how it goes.

Hi Adam,

Have you actually tried this procedure? I have yet to run into a situation where this would not force shrink the log. I have encountered many scenarios...

Use the following script to create the stored procedure "sp_forcelogtoshrink".

You can speicify the new log size by setting the @NewSize value in the script before createing the procedure

[Code]

SET ANSI_NULLS ON

GO

SET...

I am currently in the market for something similar and as far as one tool that can do it all I agree that will be hard to find.  From the...

If you want it to be support by Microsoft in a production environment you will need to be using either Windows 2000 Advanced Server or Windows 2003 Enterprise Edition.  See...