There is a UDF on http://blog.sqlauthority.com/2007/04/11/sql-server-udf-user-defined-function-to-extract-only-numbers-from-string/

that does this.

Regards,

Andras

You would need to drop this column, alter the function, add the column again. (I assume that it is not a persisted column, so it should be reasonable fast). If...

One way of doing this is to create a user defined function that takes such a string (which looks like a house number :)) and returns a similar one but:

1:...

Ananth (11/14/2007)

---

Can we able to create an query which should display the running number's or serial numbers... For example 1,2,3,4....till end of the records. Identity should not be used. Thr'...

If you want to embed SQL Server Express in your application you can either call sqlexpr.exe or you can build an installer that uses SQL Server Express's setup.exe. There is...

Sam (11/13/2007)

---

Hi, I have tried that, the problem is that you cannot declare variables in views (not unless you know of a way of doing this?). Do you...

After you create a linked server ( sp_addlinkedserver http://msdn2.microsoft.com/en-us/library/ms190479.aspx)you can specify the password and username with sp_addlinkedsrvloginhttp://msdn2.microsoft.com/en-us/library/ms189811.aspx

Regards,

Andras

Have a look at Red Gate's SQL Data Compare 6 Professional. It has a free trial. Basically it can compare databases, but it can also use database backups as the...

Have you tried any other commands in xp_cmdshell? Like:

exec xp_cmdshell 'echo a'

what does "exec xp_cmdshell 'echo a'" return to you?

Is the login you are using in the sysadmin role or...

Hi Sam,

you could use dynamic SQL like:

declare @q varchar(1000)

set @q = 'select 1 as ' + datename(month, getdate())

exec(@q)

Regards,

Andras

Mark Stewart (11/13/2007)

---

Hi Guys, I need to update the POST_CODE feild of a table by converting all the data records in the feild to upper case. Any ideas of...

Can you execute any other statement remotely? (like "select 1" for example)? This will narrow down your problem, and you will know if it is a connection problem, or a...

suhailquadri (11/12/2007)

---

...

output i got like:

dbo.sp_depends stored procedure no no...

The two most common solutions for these problems I've seen are either using Service Broker (with a queue where the MAX_QUEUE_READERS is set to 1) or to use a polling...

Sp_depends can be used in certain cases, but it is really unreliable. Much depends on the database though. If you build up your objects in...