SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Passing Pa

  PASSING PARAMETERS (not my father :w00t:) create proc Parameter_Provider as declare @login varchar(…

  Neil Burton

  4 replies

  11 years ago

  By: Neil Burton

• Fatal Error

  hi, Below 2 Error has been written in event viewer.please let me know the cause of below error. 1) …

  SAMDEV

  2 replies

  11 years ago

  By: Grant Fritchey

• Help with a SQL Query

  EmpCode..........Time...............In/Out 001----2013-10-02 06:54:00---False 001----2013-10-02 11:…

  th02b0

  3 replies

  11 years ago

  By: Mark Cowne

• audit trace enables and sql server not starting

  I restarted the sql server after c2 audit was enabled and now i can not start the instance getting …

  Tara-1044200

  2 replies

  11 years ago

  By: ermolayeva

• SSMS Table Order

  Is there a way to show tables in alphabetical order when you expand the table node of a database fr…

  lynn.huff

  3 replies

  11 years ago

  By: lynn.huff

• Separate drives for mdf / ldf on same storage

  Hi, I've been trying to read articles on this, but the information often seems conflicting. I'm awa…

  Steve Smith-163358

  6 replies

  11 years ago

  By: Jeff Moden

• please explain followin in convert datetime case

  hi, Q1)followng is from https://msdn.microsoft.com/en-IN/library/ms187928.aspx?f=255&MSPPError…

  rajemessage 14195

  2 replies

  11 years ago

  By: Steve Jones - SSC Editor

• ODBC function sequence error

  We are trying to upgrade a SQL server 2000 to a SQL 2008 R2 (SP1) server. After migrating, the deve…

  sqlfriend

  2 replies

  11 years ago

  By: sqlfriend

• Where clause question

  Hi all, i have a query needs to look for 5 records data in a table. Basically i need to hardcode. …

  kennyhuang0108

  4 replies

  11 years ago

  By: Luis Cazares

• how to decide how many number of col in a table can be made, keeping 8kb lenght to speed up.

  hi, I am making one big table which will have good no of cols, There is one critaria that is, to se…

  rajemessage 14195

  5 replies

  11 years ago

  By: Charles Kincaid

• Error handling in called stored procedures

  Hi, I have one main stored procedure. It calls other 10 stored procedures by giving input parameter…

  balushanmugham

  2 replies

  11 years ago

  By: spaghettidba

• Erro -> Error %d, Level %d, State %d, Procedure %s, Line %d, Message: Error converting data type nvarchar to bigint in EXEC(@sql1)

  Hi Guys Getting conversion error...When I use " SELECT @sql1", I get the correct syntax, buit whil…

  SQL_Hunt

  1 replies

  11 years ago

  By: mister.magoo

• How to find all SQL Server Agent Jobs that are currently running by Query

  The query below I searched from net, this returns jobs status. When I give job Id in filter of this…

  azhar.iqbal499

  4 replies

  11 years ago

  By: SQListic

• aggregate function or the GROUP BY clause Error

  Dear Folks, While running the below query, getting the error: Am I missing any of the columns to i…

  SQL_Hunt

  3 replies

  11 years ago

  By: ScottPletcher

• ASYNC_Network_IO on BULK INSERT

  Hi there, I'm seeing an issue with a "BULK INSERT" waiting on a ASYNC_Network_IO....Everywhere I lo…

  Vets5

  3 replies

  11 years ago

  By: Grant Fritchey