2015-12-23 (first published: 2015-10-19)
1,985 reads
SQL Error Logs
RE: Question of the Day for 08 Sep 2004
the following statement when given on isql prompt and then given go statement creates a Database named "GO"CREATE DATABASE GO B'coz GO is a command in isql only and that also when used as the first keyword of the line, and Query Analyzer does not need any go statement for Executing any Query hence it […]
2004-09-08
Tracking User Activity
We have an ASP web application with a VB middle tier that executes stored procedures on our SQL Server database. ASP pages call VB Dll's which execute the stored procedures. The ASP pages and VB Dll's reside on a web server and the database on a separate database server.Currently, we are using SQL Server logins […]
2004-08-24
35 reads
RE: Query Performance
I've reindexed the database and used the WITH (NOLOCK) command (forgot about that one). Seems a little better now. Thanks for the replies.
2004-08-20
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
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
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Cannot run DynamicSQL Statement to merge table with JSON
Hi there I have a problem with a dynamicSQL Statement. In this code, I...
find connection details for all ssis jobs
Hi, is there are way using sql that brings a list of the ssis...
Does SQL Server eventually terminate idle connections to the database?
We are only trying to answer the below questions regarding database connections for an...
Ask SSC