SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Copy tables from one database to another

  Anyone know how I can easily copy selected tables from one database to another? (different servers)…

  David Bytheway

  7 replies

  12 years, 8 months ago

  By: Joe Clifford

• Dynamic Where Clause for Multiple paramaters with AND Operator

  Hi I am Trying to Build Dynamic Where Clause for Multiple Parameters and they could be Null Also .P…

  Steve Dell

  9 replies

  12 years, 8 months ago

  By: Dwain Camps

• Need a redimade script or a batch file which suggests sqlserver instance up or down for any one to check when DBA is not in duty for managing initially for non-SQL DBA

  Hi to all 1.Need a redimade script or a batch file in front end without login into the ssms[sql se…

  naga.rohitkumar

  1 replies

  12 years, 8 months ago

  By: Orlando Colamatteo

• SQL 2005 3 node cluster lift and shift with IP change

  Hi SQL Experts, We have a activity coming up in our project where sql server 2005 three node cluste…

  Bipsy

  4 replies

  12 years, 8 months ago

  By: Perry Whittle

• Log Shipping Mystery

  I have a very mysterious and stange issue with Log shipping backup jobs: I have over 60+ dbs and th…

  wmbldonwannabe

  1 replies

  12 years, 8 months ago

  By: Perry Whittle

• cte - error 'has fewer columnns than were specified in the column list

  I dont quite understand the error I am getting here. if you run the query without using the set, i…

  kcbjcb.brown

  3 replies

  12 years, 8 months ago

  By: kcbjcb.brown

• SQL Server 2005 ODBC Connection Discrepancy

  Alrighty, so here's the issue (Question is Below): We're having trouble trying to establish an ODBC…

  RockFistChris

  1 replies

  12 years, 8 months ago

  By: Orlando Colamatteo

• DBCC Error

  When I run the DBCC against a specific database I get the following error. I have researched this …

  rcjunk

  2 replies

  12 years, 8 months ago

  By: Orlando Colamatteo

• Where clause Case Statement and IN

  How do I correct the following statement: Declare @Component smallint = -1 …

  Faye Fouladi

  6 replies

  12 years, 8 months ago

  By: Dwain Camps

• Is there a loop in this query

  Hi Can anyone see a loop in this query SELECT AA.[Country Code], SUM(extendedamount) AS Am…

  olivia.forde

  12 replies

  12 years, 8 months ago

  By: Jeff Moden

• Database Connector Error: 'Cannot obtain error message from server.'

  When I attempt to add a new SP to a report I get the message stated in the subject. I can add exist…

  JayWinter

  1 replies

  12 years, 9 months ago

  By: JayWinter

• Trying to get a proc that I call with 1 parameter to put the results into a tempory table

  I need some help please. I have 1 table of Lots and 1 table of Owners (see atchs 1 & 2 for tab…

  jrichards54

  4 replies

  12 years, 9 months ago

  By: jrichards54

• free online backup

  If your looking to backup your files, photos, music or videos online for FREE, use this exclusive l…

  stump_83

  1 replies

  12 years, 9 months ago

  By: Jeff Moden

• Invoked Schedule Id of the Job : Urgent!

  Hello: When a job step is being executed from SQL Server Agent, I need to determine the "schedule_i…

  ganeshmuthuvelu

  16 replies

  12 years, 9 months ago

  By: ganeshmuthuvelu

• bulk insert blocks nolock query

  I have a SSIS package that is truncating and then inserting a whole table from serverA to serverB, …

  mvillegascuellar

  3 replies

  12 years, 9 months ago

  By: GSquared