Thank you very much for a great function. However, i need every characterdigit that are after the 'ABCD'
my fault...forgot to add... above script is a beginning of the loop... here is what following the script above: set @iT=1 WHILE @iT<=(SELECT MAX(iT)...
T SQL GURUS, I NEED YOUR HELP !!! DECLARE @fileCode CHAR(4)DECLARE @T table (iT int identity, fileCode char(4))DECLARE @iT int SET NOCOUNT ON...
Thank you, Adriaan! I'm sitting here with my jaw open....
by default SET CONCAT_NULL_YIELDS_NULL database option is set to False but... when I'm running the select 'abc' + null , getting the result as a...
thanks
Hello Everyone! My question would be:What are the best practices for configuring SQL cluster services and groups.Does it make sense to have only one...
Here is more details: Windows 2003 standard, sql 2005 sp2, QA environment: 1. Cluster group name - CL12. Consist of two active/passive nodes...
Windows 2003, sql 2005 sp2 cluster when you open up a sql server properties.... one of my systems shows virtual sql server name second one shows the...
i think one of them that a must to have is an ' insufficient permissions' alert.
Hello Everyone, windows 2003 enterpr, sql 2005 sp2 we have 30 dbs, and every one of them have the same Scalar-valued Function. Also, a windows auth...
Thank you, Luis can you pls be more specific? which tool are you talking about?
Hello everyone, we have this monthly data refresh, when we copying data from production to our QA environment it involves more than 40 databases and...
Thank you, for some reason I was sure that if user is apart of the security admin server roll, which is server level roll that he has all databases...
Thank you, Satya it was very helpfull as per your link: Among all network protocols provided by SQL Server 2005, Shared Memory is not supported on...
Thank you MohammedU, but we running sql 2005. Link that you sent is for sql 2000 installed on Win 2003
Hi, here is the problem: we have new cluster installed, i was not able to open the error log, message was that named pipes protocol is not configured...
ectually i did included them in the security admin roll as well as a dbcreator....still not enough they are still not able to execute...
thats exactly what i already did, dbcreator and sec admin, still not enough......
Hello, everyone we have a tech department that adding new databases (restore from a backup), creating new logins and assigning deferent database...
Separate names with a comma.
