Hello,I restarted my machine yesterday and sql agent didn't start eventhough it is set to start automatically. It runs under windows...
Hello Experts, I am using the feature in sql server 2008 to generate scripts for all the tables within a database. I see an option "If not exists...
Thanks for your reply Adriaan... Perhaps I have to do, select POWER (1.8, @Column1) * CAST(10000.0 as float) if I do this, I get an error:Msg...
I imported some data from text file to sql server 2008. Import Export wizard created a table with varchar(255) for some columns which had float data....
Hi All,Here is my scenario.I have two tables T1 (Sid int not null, Pid int not null) & T2(Sid int, Pid int). T1 has composite primary key on (sid,...
I am finding weared behaviour on different servers I work with. All of them have same SP being called from front end to fetch data. SP is using...
Hi All,I have a question on inserting data to a table where some data already exists and I don't want to add them again. here is the scenario,I have...
okay let me try this..Thanks
Hi All, I have a text file with one column where some of the data is blank where some of the records have some values like 0.9, -2.3,3.0,4 etc. I am...
Hi All,I need to find Same Column Names (duplicate columns) in a set of tables. ex. I have a database which contains 20 tables and some of those...
Well, I cant use XACT_ABORT as the script is written in a way that it creates hundreds of tables, stored procs without using BEGIN/COMMIT/ROLLBACK...
Hi, I have a script worth 1000 lines which creates DB & other many objects. I am using TRY CATCH & RAISERROR in my stored proc to trap the errors....
Thanks...
Hello, can anyone help me with some links on how to create a batch file which will run my T-Sql scripts? Aim here is to execute the scripts by batch...
I do have a sql installed on the system, but I am not installing SCOM on SQL instance.
Hi All,I came across a problem while installing SCOM 2007 on windows server 2003. "Setup failed to verify the presence of Active Directory for this...
Hello All,I am trying to install SQL Server 2005 Developer edition on windows server 2003 where I allready have SQL 2005 Enterprise Edition...
Hello All, I think I am posting this in a wrong subject but I couldnt find any specific option and thought of posting this here. I would like to...
During performance monitoring for Load Test on few servers. I have configured following counters in system performance monitor. Can anyone tell me...
Separate names with a comma.
