Viewing 15 topics - 265,816 through 265,830 (of 269,612 total)
What I'm using:
MS Sql Server 7.0
DTS saved as local packages.
SQL Server enterprise Manager
17 years, 7 months ago
In: Data Transformation Services (DTS)
I've just seen microsoft access 2002 feature list. Some new functions and enhancments and there are…
By: Andy Warren
How can I use DMO to shrink a database and log file?
I have a stored procedure that takes 38 seconds during an Application stress test BUT when I run it…
I have been trying to figure out a way to audit some databases in SQL Server 2000. I want to have …
Is there any undocumented command or script to find out the space used in individual data files of …
By: Steve Jones - SSC Editor
I am just starting out in the database field.
I am taking oracle in college. I understand that sql …
17 years, 2 months ago
I am trying to connect one SQL server 7 to Another SQL Server. My Query is : select * from ServerNa…
Setting: Test lab, Sql 7 with Sp 4. Want to upgrade all Sql 7 DB's to run under Sql 2k.
Is it possible to pass parameters to a cursor in t- sql, as we can do in PL/SQL?
I need to …
14 years, 11 months ago
I get duplicate rows in my results. I am sure it is my query:
I have a stored procedure like :
CREATE PROCEDURE TestSP
I was working in a project VB+SQL Server. I was little bit confusion about recordlockin…
I'm using SQL Server 7.
Is it possible to passing Table Name / Database Name as parameter in …
By: Johan Bijnens
SELECT tbl.id, tbl.sku,
tbl.sizevalue + ' ' + tbl.colorvalue + ' ' + tbl.widthvalue as sizecolorwid…