SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Stored procedure that takes backup of your procedures on physical drive

  I am getting error while executing this stored procedure Please help. /*===========================…

  Aadhar Joshi

  4 replies

  13 years, 5 months ago

  By: Aadhar Joshi

• Need stored procedure in sql 2008 which scripts all the database

  We used the below procedure to script all the Databases in sql server 2000 CREATE Procedure dbObjec…

  rj529

  4 replies

  13 years, 5 months ago

  By: WWDMark

• Virtual Environment for Sql server ????

  Anybody has any idea any website or URL give any virtual enviroment where a sql server (mgmt ) env…

  Bhuvnesh

  2 replies

  13 years, 5 months ago

  By: Bhuvnesh

• Script to create realistic generic financial data

  Hi SSC, This morning I was doing some work from home on some work transcribing a financial algorith…

  Xedni

  2 replies

  13 years, 5 months ago

  By: Jeff Moden

• Execute scripts from directory by desired order

  Hi All, I need to execute 300 .sql scripts from a directory. They are named like: 10001.name1 10002…

  Igor Micev

  4 replies

  13 years, 5 months ago

  By: bleroy

• how can i write 2 select statements in single procedure

  Hi all, how can i write 2 select statements in single procedure.

  sandeep.vemulas

  11 replies

  13 years, 5 months ago

  By: Steven Willis

• SQL Service Broker - Administratively Disabled

  Have implemented SQL Service Broker at one customer's site and it is up and running fine. Took the…

  J_C

  2 replies

  13 years, 5 months ago

  By: purpletoad

• Performance issue while fetching 20000000 records

  I have some 20000000 rows in my database. While fetching records on some criteria it take too much …

  priti 19979

  6 replies

  13 years, 5 months ago

  By: Thinknook

• what is new method in create a script in (scptxfr.exe') for 2008

  what is new method in create a script in (scptxfr.exe') for 2008

  rj529

  1 replies

  13 years, 5 months ago

  By: Thinknook

• how to store perfmon data(.csv) into sql table.create a schedule job

  how to store perfmon data(.csv) into sql table.create a schedule job

  rj529

  2 replies

  13 years, 5 months ago

  By: rj529

• How to find which are all databases are in use in sql server 2008

  Hi, I have a SQL Server 2000 box that houses several databases, some of which are probably no longe…

  nhimabindhu

  9 replies

  13 years, 5 months ago

  By: Gail Shaw

• Capacity Planning

  Hi All, I was asked to do capacity planning of SQL 2005 & 2008 servers. What are some of the …

  SQLisAwe5oMe

  3 replies

  13 years, 5 months ago

  By: bjcharles

• Script to get list of databases for which a user has db_owner database role ?

  What is the command to get list of databases for which a user has db_owner database role ?

  Mani-584606

  3 replies

  13 years, 5 months ago

  By: AJ@SQL

• Database disk usage

  IS there a sp to show disk usage of a Database?

  SQL_Loser

  3 replies

  13 years, 5 months ago

  By: Ant-Green

• Changing Column Data type

  Hi We need to change int column to bigint data type on a primary key column. So we generate script …

  k.thanigaivel

  7 replies

  13 years, 5 months ago

  By: Ant-Green