guptaajay1985 (12/2/2008)

---

Dear All

I have a opened a system in it SS2K5 is installed but when I see its base folders placed at "E:\Program Files\Microsoft SQL Server" then I have get...

check out this

using System;

using System.IO;

using System.Net;

// uncomment using System.Diagnostics; for debuging

// using System.Diagnostics;

using System.Text.RegularExpressions;

using System.Collections;

using...

you can...

viji (11/27/2008)

---

Hi kshitij kumar,

It is a server and it doesn't have extra space to load in any other drived.

and Ajay, it iz a server in australia so we cannot reinstall...

Paresh Prajapati (11/27/2008)

---

Hi guys,

I have to implement spell checker from database side..

suppose i have entered wrong word from application which is text field..

like "cay"..so it will found very nearly correct...

viji (11/27/2008)

---

Hi,

we've deleted 11GB database. we have the back to restore it.

but even after 12 hours of deleting. The space in the hard disk is not cleared. To...

drjdewhurst (11/27/2008)

---

Good Morning all.

My problem is that I have a table containing over a hundred thousand records. The table has the following columns: ID, X, Y, Latitude, Longitude.

What I need...

Jinx (11/27/2008)

---

Hi,

I have two tables within the same database, both have several datetime columns in the format i.e. 27/11/2008 11:44:28.

A user defined function to get working minutes between two...

TNV (11/26/2008)

---

Hi Kumar,

Basically I am new to this SQL Server stuff...

I am using MSSQL Server 2005 Express. I turned on trace by using DBCC TRACEON (1024). But in the errorlog,...

oksanamarch (11/15/2008)

---

Hi everyone! My name is Oksana, I am from Russia! I was before crystal reports developer but now another girl who was SQL Server DBA left the firm I...

prashant_j42000 (11/26/2008)

---

To freeup the cache information

SELECT [cp].[refcounts]

, [cp].[usecounts]

, [cp].[objtype]

, [st].[dbid]

, [st].[objectid]

, [st].[text]

, [qp].[query_plan]

FROM sys.dm_exec_cached_plans cp

CROSS APPLY sys.dm_exec_sql_text ( cp.plan_handle ) st...

thenewsview (11/26/2008)

---

Hi,

I have an application which is running from two terminals. If, the applications from two terminals updates the table in database simultaneously, one of the application is getting a...

Arif Hafeez-Imam (11/26/2008)

---

Hi,

Does anyone know how I can pull just the numeric value from a varchar field which contains both numeric and characters?

eg.

if the data stored was:

"40 Words"

or if the...

lav (11/26/2008)

---

i m creating stored procedure i want to fetch data in this stored procedure .i was using cursor but its performance not good so ant alternative solution of this...

m.bansal (11/26/2008)

---

Hi all,

I have 100 package in my project. I need to deploy this project to some other server. At that time i am using sepearate connection for each project...