Azure Cosmos DB

Technical Article

RE: DBCC CHECKDB return Errors

  • Reply

This is why I'm not a fan of using Maintenance Plans.  I much prefer to code all the jobs myself so I get detailed output.  When I'm in DBA mode (I'm currently doing SQL development) I use ISQL to run my DBCCs and pipe the output to a text file.  It's run as a batch […]

2005-04-15

Technical Article

RE: Error 3709 The connection cannot be used to perform this operation. It is either closed or invalid in this contex

  • Reply

i would bet that a connection string is incorrect when it is moved to production...I don't know your app of course, but if the connections string is hardcoded to look for a specific machine name, ip address, database name,  then it might fail;check the basics of the connection string:from the production machines perspective,does the server […]

2005-03-16

1 reads

Technical Article

RE: sql server Raiserror function

  • Reply

My guess would be that there would only be extra overhead when the RaiseError was invoked (Maybe not even then).You could test it by running a script without any RaiseError statements then adding the RaiseError statements and comparing the results.  If the timings are the same with no errors conditions, then you should be okay. Hope […]

2005-02-14

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

How to append data to the previous row

By jay-125866

Hi, I have a table that stores event transactions, the sample data see the...

Replacement for char and ascii functions in natively compiled stored procedures

By MullerN

I am trying to create a natively compiled stored procedure where I need to...

Do entry-level cloud positions exist?

By nadolguna

Hello friends. I’m new here, so if this is the wrong place for my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers