Does the application run on the same host as the database server? If the application is on a different host, try connecting from a client using the application's connection string,...

Sorry, I was thinking about this BOL page http://msdn.microsoft.com/en-us/library/ms143504%28v=SQL.100%29.aspx, particularly for the computer that is not in the domain, if I have read the thread right.

Are you using certificate authentication to connect the endpoints? Windows authentication won't work if the SQL Server services are not both running under trusted domain accounts.

Administrator might be okay...

Hi,

If the resulting string is intended to be Oracle SQL, you will need to supply a date mask.The parameter should be a string; assuming that it is coming from...

Hi,

I would suggest saving it as a datetime, as this will give you more flexibility for analysis. Possibly with a separate date-only dimension for querying/partitioning. For example, in our...

<-- I think this looks like a nice marmot.

Any thoughts, anyone? Is this a feature you would like to see?

None really, as long as it is not locked and you know the password. (Log on as a service is granted during installation I think.) Check that the server has...

My 2¢ is option b) - just disable the services. (If you need to free up disk space in future, you can delete the INST2 database files then.) As long...

Jinx-640161 (11/26/2010)

---

Yes, particularly if they have made a...

Jinx-640161 (11/26/2010)

---

What I find interesting is how many jobs in the UK are advertised at one salary, then when you apply you find out it's for far less...This seems to...

This has been a very valuable thread to read. Maybe the OP might be interested in this disk partioning article: http://msdn.microsoft.com/en-us/library/dd758814.aspx.

One point I did not see discussed was:

oracle_dba_newbie...

Hi,

Is SSMS running on the PC (say under an account which does not have permissions on that particualr SQL Server)? I had a lot of login messages logged on...

Database Mail and SQL Mail are not available in SQL Server 2005 Express Edition. (See the BOL topic 'Features Supported by the Editions of SQL Server 2005'.) HTH

AFAIK when a computer joins a domain, the Domain Admins group is added to the <SERVERNAME>\Administrators group. So when a SQL Server is in a domain, this makes <SERVERNAME>\Administrators equivalent...