Nice question! Again, I've learned something new about VLF.

You can test it out with the following script:

CREATE DATABASE Test_DB

GO

USE Test_DB

GO

DBCC LOGINFO;

In the column Status, a status = 2 means active...

Have you set-up windows authentication?

Is it a named instance?

Did you give yourself administrator permission?

Try logging in with . as the servername. (the dot represents localhost)

No problem, glad to help.

sql_butterfly (1/11/2011)

---

We are going to be migrated to SQL 2008 sooner or later. What things we need to keep in mind while migrating ? To be precise, I am talking...

This should get you started:

http://msdn.microsoft.com/en-US/library/ms137712(v=SQL.90).aspx

Grant Fritchey (1/11/2011)

---

On #3, if you change the data type on existing data, you face the possibility of data loss, which, for most businesses, is a bad thing. So when...

Yes, you can do a backup and a restore without shutting down SQL Server.

For more information, see the following link:

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

Make sure to also check the references at the bottom.

How are...

Is the server running on your local machine?

How are you trying to connect?

http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

The things I like...

a.e.ghorbani (1/11/2011)

---

i have one user that has sysadmin permision .i have 13 user that has only public permisison .

i dont want to give 13 user sysadmin permision but i want...

Carlo Romagnano (1/11/2011)

---

Koen (da-zero)

And what if your company or your client uses an older version of SQL Server (there are still some SQL 2000 or older out there. SQL Server...

It could be a DLL issue.

Check out the following thread: (it is roughly the same problem, only with a data flow task instead of an execute package task)

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/de4607a6-27b2-4934-b767-3ce6cc93e334/

Carlo Romagnano (1/11/2011)

---

I get it wrong, because I don't...

Since the XML file must be ready to be read when the package opens, I think it is hard to apply encryption to the XML file itself. What are you...

You should post the exact error messages, it would really help us to help you.

My first guess is that the package fails in validation. Try setting the DelayValidation property to...