A SQL Server have a very bad perfomance which is in cluster environment. Need to do a immediate analysis. But not familiar with the applications or...
Hi Experts, This is a funtion to Parse values. This is working fine in sql 2000. Since FUNCTION is not supported in SQL 7, it is not working. Can...
Hi Please help me I have to create a SP. The secenario is that, A application calls the SP with a parameter(login), and a string of datas ( Acctid...
Hi Experts, I have been given a task to do a load test in SQL. The test is to put a load in the SQL server (large or purposely deadlocking query on...
Hi Experts, I tried running a Store procedure from two servers, in one server it was working fine, but while running on other server, i am getting...
Hi, ALTER TABLE table 1 ADD column1 money NUlL DEFAULT '0', column2 int NUlL DEFAULT '0', column3 money NUlL DEFAULT '0' while...
Hi Experts, I have to find the discrepancy between two tables I have Table 1 with columns OrderID Date Quantity Symbol Table 2 with columns OrderID...
Hi, I have a table with C1- ID C2-Date C3-Date with time C4-quantity I need to create a daily process that will remove the oldest data(data older...
Hi, while executing sp_who i got the below result Spid Status Login Host Blk Dbname cmd 22 sleeping sa XXXX 0 User_DB Awaiting cmd sp_who displays...
Hi, I have been given a project plan to leave only 30 days of History on 3 tables (T1, T2, T3) on SQL 7.0. But all the historical information...
Separate names with a comma.
