End of day bump ...

Not a bad idea Cliff, but no go ...

Kenneth Langner Jr. (6/11/2010)

---

Try this out:

http://msdn.microsoft.com/en-us/library/aa337083.aspx%5B/quote%5D

Thanks Ken, already went through it.

Kenneth Langner Jr. (6/11/2010)

---

I saw you have: The local SQL2005DTS group.. If they are on SQL 2005 they won't be able to connect to SSIS in SQL 2008. You...

Check your error log to get the full error ... More than likely you'll need to google that and you'll find that it's probably a service pack and/or cumulative update/hot...

I went through this oh so fun exercise not all that long ago (http://www.sqlservercentral.com/Forums/Topic830172-1042-4.aspx#bm846351).

Basically ...

- Install the Oracle Client (you only need the OLE DB component)

- Set your tnsnames appropriately

-...

shannon714 (5/6/2010)

---

Adam,

It's been a while so I hope you already found your answer. If not, Tim Ford had a good tip to put this at the beginning of...

SSMS/SQLCMD,...

MeltonDBA (4/23/2010)

---

Just a shot in the dark...but on the Connect to Server prompt when you open SSMS look at Connection Properties and see if "Connect to database" is set to...

IF EXISTS (SELECT [name] FROM sys.server_principals WHERE [name] = 'MyDomain\MyGroup')

DROP LOGIN [MyDomain\MyGroup]

GO

CREATE LOGIN [MyDomain\MyGroup] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]

GO

When running a new query in SSMS, it defaults me to...

Interesting, the lasttime is always 0 even in 2000, crap.

So is this data available anywhere?

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e83b5ded-8cda-468d-ac36-1b8c31b1073b

It turns out that the label is very confusing. There is a bug filed on it in the SQL bug database and it will hopefully get fixed in the...

Interesting, I as well have this ...

Being that SELECT SERVERPROPERTY('Edition') is telling me 64bit, and my o/s is telling me it's x64, I'm pretty certain that it's simply something wrong...

You and me both. I just dropped...

MeltonDBA (4/23/2010)

---

The only though I have is on this page it mentions:

When you first connect to an instance of SQL Server, the default database for the login...