Viewing 15 topics - 279,466 through 279,480 (of 280,897 total)
I am just wondering if it is possible to give permissions to a login to run profiler without as…
21 years, 10 months ago
By: Steve Jones - SSC Editor
In SQL Server, are "index trees" also stored in the buffer cache? for example, if I ran a query …
20 years, 11 months ago
Hi, again, I have been struggling to figure out how to translate Celko's SQL-92 standard code into …
What not use a 7.0 Backup, then Restore that to a 2000 DB ?
Why is it no one ever recommends this f…
I have just 'inherited' an inhouse app which uses DMO to maintain metadata info & recreate scr…
By: Andy Warren
Has anyone executed a DTS package from VB.NET yet? Care to share your code?
we have two sql server instances on sigle server. One instace is sql7 another is sql2000. Server ha…
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 …
21 years ago
I ran into problem when I set FormatMedia property to TRUE in backup object. if I do not set th…
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. …