Tally Table

Technical Article

RE: Independize DTS from the enviroment

  • Reply

We use Global Variables along with a case statement to change the Server and Database information in production. The following code is put into a ActiveX script that is the first task to run: Select Case DTSGlobalVariables("Environment").Value Case "Development" DTSGlobalVariables("Server").Value = "Server1" DTSGlobalVariables("Database").Value = "Database2" Case "Production" DTSGlobalVariables("Server").Value = "Server2" DTSGlobalVariables("Database").Value = "Database2 Case Else […]


1 reads

Technical Article

RE: data modification

  • Reply

Yes, though I don't know of many who would recommend it. For SQL 2000 (don't remember if this worked in 7.0): In EM, right click on a table in the database in question, select Open Table, return all rows. Pops up an editable grid. SJTerrill


Technical Article

RE: TempDB

  • Reply

TEMPDB can fill up and lock users/queries if you don't have it set to automatically grow enough. Notice I said 'enough'. The growth size has to be enough that it can grow faster than the space is filled up. For example, lets say you set it to auto grow by 100 MB. You get a […]


Technical Article

RE: Server slow down after stopping replication

  • Reply

Hi all, I have experienced a similar slowdown in EM performance. Removed replication from our server and the database is performing fine for our users, but not while trying to perform basic actions via EM, example opening a restore db window can take several minutes. Any ideas would be appreciated. Thanks, Robert



Deadline for Microsoft MVP contributions is 20 March 2023


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

Goal Progress for Jan 2023


The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger


Does Context Info work across databases? This post shows it does. Another post for...

Read the latest Blogs


Storing a text file in a VARCHAR(MAX) column

By Mick Opalak

I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...

"ID" primary key from two separate tables as a foreign key in a new table

By Edub1122

I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...

blocking issue

By vsamantha35

Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers