Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin...

I have to genrate a Store procedures script from SQL sever 2000 when i try to execute these script on Sql Server 2005 it gives the following Error "Msg 15157,Setuser failed because of one of the following reasons: the database principal 'nust' does not exist, its corresponding server principal...

Hi Everyone, I am wondering if anyone has any tips on either SQL Server configs or MS Server Configs when running your Db's on a Fibre Channel SAN. The Config is, I have 6 servers attached to a FC SAN. Each server has a dual port FC NIC. The servers are attached to both of the 2x FC switches and...

I'm having a problem executing a SQLCLR function: this function calls a web services that processes a query to a data base and returns a table to be used in a stored procedure. In a low concurrency scenario (not to many clients connected), the function returns correctly, however when the concurrency...

Hello, my name is Tim and it is my first post on sql-server-performance.com I have a problem with the duration of a sql-query, but I don't know how I can optimize this. Here are the database-tables: Table1 (2.600.000 lines): A_CODE (PS,int, NOT NULL) B_CODE (PS,int, NOT NULL) C_CODE (PS,int, NOT...

hi, what is the usuage of with nolock property. thanks in advance.

Hi I set up an 2 node active-pasive clustering using SQL server 2005 and windows 2003. I was using it well when I connect to this instance I used like "server1/inst1" to designate the instance. later I tried install another instance to this cluster on an active machine however installation...

Hi Everyone, The following article I read puzzles me regarding the Paging File, http://technet2.microsoft.com/windowsserver/en/library/00284c8d-7a42-40f2-8a01-8de61dccd8c91033.mspx?mfr=true. "... Under such circumstances, the effectiveness of this large of page file could be minimal, based on the...

Hello there, I'm searching for the best solution to scale out transactional replication with hundreds of publications, and that's the situation: we use transactional replication (push, no update) with almost 100 articles (tables and sp) on sql2k5. We've the online database, that expose a...

I inherited a SQL 2005 server. Initial installation has the sytem DBs on the O/S partition. So were all the user DBs. I was able to move all the user DBs to another partition and want to do this with the system DBs but have been running into problems. I have read everywhere that talks about using SQL...