thank u very much for the prompt response

Bru Medishetty (11/18/2009)

---

Use the Following T-SQL Command

SELECT DATABASEPROPERTYEX('DBNAME', 'Collation') SQLCollation;

You can also right click on the database select properties. In the general page of the Properties window, the last...

Silverfox (11/5/2009)

---

shanila_minnu (11/5/2009)

---

i need the substring from a column in such a way that i should get the string from 9th to 16th.below qury is throwing error.pls advise

SELECT SUBSTRing

(description,

select charindex...

can...

how can we test ODBC connection

it is namedpipes/tcp

sql is running and login is valid

shanila_minnu (11/2/2009)

---

shanu.hoosen (11/2/2009)

---

Hi,

This could have multiple causes

1. try connecting to sql to ssms with your user credentials

2. ensure the correct protocol is selected under SACM,i.e named pipes and tcp/ip

not sure...

shanu.hoosen (11/2/2009)

---

Hi,

This could have multiple causes

1. try connecting to sql to ssms with your user credentials

2. ensure the correct protocol is selected under SACM,i.e named pipes and tcp/ip

not sure what...

i am using sql...

is this Stored procedure used to delete the history of jobs?????

can you give me the script to delete thel ogins

fro where can i find the explorer view in ssms...pls can u help me for that...i just want to delete all the related details of that 6000 logins...

Silverfox (10/22/2009)

---

shanila_minnu (10/22/2009)

---

i have 6000 logins in one of the server.in this i need only 30 logins now.how can i delete it in one stretch without disturbing the needed 30...

shanila_minnu (10/20/2009)

---

Steve Jones - Editor (10/19/2009)

---

the name of servers or databases? Are you centralizing backups from multiple servers?

VBScript/Powershell might be the easiest way. you can write a script to delete...