Viewing 15 posts - 10,516 through 10,530 (of 11,678 total)
tan110 (1/11/2011)
I'm manually executing the SSIS via a .cmd file using dtexec.
Make sure you use the dtexec from the 32-bit program folder.
January 12, 2011 at 7:53 am
R.P.Rozema (1/12/2011)
January 12, 2011 at 7:51 am
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...
January 12, 2011 at 12:05 am
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)
January 11, 2011 at 11:48 pm
veena.jokhakar (1/11/2011)
Thank you so much for clear cut explanation.
No problem, glad to help.
January 11, 2011 at 11:38 pm
sql_butterfly (1/11/2011)
January 11, 2011 at 11:36 pm
This should get you started:
http://msdn.microsoft.com/en-US/library/ms137712(v=SQL.90).aspx
January 11, 2011 at 7:46 am
Grant Fritchey (1/11/2011)
January 11, 2011 at 7:08 am
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...
January 11, 2011 at 3:45 am
Is the server running on your local machine?
How are you trying to connect?
January 11, 2011 at 3:39 am
sql_butterfly (1/11/2011)
Hello everybody, Can anyone tll me which positive things to look out for while migrating from SQL 2005 to SQL 2008 (FROM DEVELOPER POINT OF VIEW)
http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
The things I like...
January 11, 2011 at 3:37 am
a.e.ghorbani (1/11/2011)
i dont want to give 13 user sysadmin permision but i want...
January 11, 2011 at 3:32 am
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...
January 11, 2011 at 1:54 am
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)
January 11, 2011 at 1:09 am
Carlo Romagnano (1/11/2011)
Koen (da-zero) (1/10/2011)
Good, but difficult question. I had to read quite some BOL pages to get this one right.And only 1 point?
I get it wrong, because I don't...
January 11, 2011 at 1:02 am
Viewing 15 posts - 10,516 through 10,530 (of 11,678 total)