So yep it is a platform issue now you know why most production...

gmamata7 (11/18/2009)

---

Hi,

I'm installing SQL Server 2005 and at the end of installation I have noticed Visual studio 2005 in ALL Programs list. So this Visual studio 2005 is required?...

dndaughtery (11/18/2009)

---

I am used to working on a machine with a 2.9 gig processor and 64 Gig of RAM. I am now working on a machine with a 2 Gig...

Nick Kernick (11/18/2009)

---

right im being totally thick here. I dont want to "open" up an sql services to the internet

i have had servers totally ruined by people hacking into sql...

Gianluca Sartori (11/18/2009)

---

It might not be the right answer, but check your code for DDL operations inside of TRY/CATCH blocks. Even if your code runs perfectly without a transaction when...

Nick Kernick (11/18/2009)

---

Thanks for your reply, however iam new to this

The servers sit on the internet in their own little world. They dont talk to each other.

and dont think they...

You can convert the User instances to server instances and use other SQL Server in your network to create replication using the two as subscribers. The Express can be...

lokhande.deepali (11/18/2009)

---

Hello,

Is their is any Script to change collation of user database ?

The process Which I know;

First Backup the User database

1.creation of new database with required collation (create...

TNSNAMES.ORA is a Network Configuration file in the location C:\Oracle\product\11.1.0\client_2etwork\admin (Per my Server where Oracle 11 Client is installed) that stores the Host Name, Protocol and Port for the Oracle...

Bru Medishetty (11/17/2009)

---

TNSNAMES.ORA is a Network Configuration...

Oracle require Oracle client installed for all development tasks and make...

Here are the collation definition when Microsoft says Expression it means collation in your queries which is new to SQL...

The Master database is one of the system databases there should be no default login to it because system admin role...

AlexSQLForums (11/16/2009)

---

am-244616 (11/16/2009)

---

Guys,

I see the following error in the event viewer and sql server logs every min

Login failed for user 'NT-DOMAIN\services'. Reason: Failed to open the explicitly specified database....

You can add the...