changing permissions shouldnt require an agent restart, just a password change.

i believe for 2005/2008 you just have to have the proof of purchase for the processor licenses or user/device CALS if your per user licensing. as long as the...

books online is your best starting place

GilaMonster (12/7/2009)

---

Changing the recovery model to Simple...

got it...

http://www.sqlservercentral.com/articles/T-SQL/67898/

as far as i know there isnt an option to disable logging, except of course changing the RM to simple. Do a search in the articles from Lynne Petis...

ask the application developer what credentials they are using to connect from the application. then you decide if thats what you want them to use.

ok im not 100% what the issue is but the error seems to mention keys. go back to your SSIS package in BIDS and left click anywhere on the...

Hi Jona,

you probably want to be looking at an SSIS package using a data flow task with an Excel source and OLE DB sql server destination. That way...

ok thats interesting. does anyone else have SSMS on their machine, and if so is the service state missing for them too?

one other thing to try, connect...

xnleiden (11/27/2009)

---

I really don't want this thread sink in vain like all others that I can find from Google.

I used the 'sa' account and SQL Server authentication to connection from...

it doesnt matter what your connection to the server is in SSMS, its all to do with whether your windows account your using has access to the services information on...

Pass, the link to the technet site seems to be for 2005 documentation, so there is a chance its been removed from 2008 although i dont have a 2008 server...

Note that the option will be removed from a future version of SQL.

IMO if you have a nullable field in a concatanation then you should always stick isnulls round each...

As Jeff has already said you start an SSIS project and add existing item. when prompted for the connection type is sql server (not file storage) as this looks...