Viewing 15 topics - 265,831 through 265,845 (of 267,257 total)
we have two sql server instances on sigle server. One instace is sql7 another is sql2000. Server ha…
17 years, 7 months ago
By: Steve Jones - SSC Editor
SQL 7.0 sp3. In my sql server properties, I have connections set to 0(unlimited) However it will o…
Looking for advice on inserting data into a table using a SP called from a VB front end.…
By: K. Brian Kelley
Can we take Transaction Log BackUP after Database got currepted. If so How?
Iam preparing for 70-028. I have confustion for the following question.Can any one explain what is …
16 years, 8 months ago
I ran into problem when I set FormatMedia property to TRUE in backup object. if I do not set th…
17 years, 6 months ago
By: Andy Warren
We are in the process of Migrating to SQL Server 2000 from SQL Server 7.0.
There will be two new Se…
I have a SQL Server 7.0 question, and was wondering if any of you had any ideas, etc....
I was very excited when I heard that I can debug stored procs from Query Analyzer in SQL 2000. …
I know that there are a lot of tools to compare databases etc..
But cannot use these(don't ask)
I am using BCP utility to export and import data.
The column data look something like this:…
I need to execute Dynamic SQL in a user defined function after passing the table name a…
By: William Markham
i have a query in a Store Procedure which changes as per the parameters passed to it...
I have a cube with two measures "Margin Percent" and "Order Quantity" respectively.
1 month, 3 weeks ago
In: Analysis Services
By: Joe Kelly-8908
I'm totally out of my experience on this one so expect something dumb....
I want to keep the databa…