SQL Server Tools

I don't know if I have missed something here, but I blindly thought that if I used SSMS to script my database, I could run the script on a new instance and get a database out of it. The script fails, and I get an error saying that a stored procedure requires ...

Hi guys, I dont know if im in the right group.  My scenario is like this. Transaction logs are eating up my server's hard drive. Almost 60% of my space is transaction log.  What are these? Can I simply delete it? Can I ...

Is it possible to save your Database Engine connections in SQL Server 2005 Managment Studio Object Explorer, so that the next time you open the Management Studio you don't have to reconnect? Thank you! ...

I am having very strange issues with SQL Server 2005 Integration Services. Originally I was having trouble due to a SP issue. Product Level Insufficient. I installed SP1 and then SP2 for SQL2005 and the issues stopped but have now reappeared BUT intermittently! I can run a simple package and it ...

How do I modify a Managment Plan to add conditions? I assume I use SSIS, but do I build a new Management Plan in SSIS or do I modify an existing management plan already in SQL? If I modify an existing plan how/where do I ...

No idea if this is the right forum for this - could not find an SSIS forum anywhere. I'm working with this for the first time and finding it very weird. Nothing seems to work intuitively. I'm trying to set up a simple package and it is ...