Make sure you use the dtexec from the 32-bit program folder.

R.P.Rozema (1/12/2011)

---

Thanks for your responses. I managed to downgrade the packages. I need to thank a colleague -with great Google skills- for this, who sent me this link that references...

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