Viewing 15 topics - 280,591 through 280,605 (of 283,916 total)
Topics
Started by
Posts
Last post
Hi All, I want to store an image file of any extension (gif,jpeg etc.) in SQL Server 2000. How can …
3 replies
How do i create a stored procedure which comes up with Type='System' in Sql database. Even when i u…
5 replies
We have a procedure that updates a temp table several times by joining it to different permanent ta…
6 replies
USE MASTER GO IF OBJECT_ID ('SP_PH_WHO2') IS NOT NULL DROP PROC SP_PH_WHO2 GO CREATE PROC SP_PH_WHO…
1 replies
Is there a way of getting table-name from the given PageID? For example, "SELECT waitresource FROM …
3 replies
Hello everyone, I wanted to know how I can see which database and server options are set (through s…
7 replies
Hello all, I have about half a Gig of memory on one of my boxes. There is one user connected and i…
4 replies
I need to copy msdb database to another server on same network different Server Name. What's the b…
1 replies
For some reason the optimizer is not using my clustered index. I am trying to specify a HINT to for…
1 replies
How do you change the Lock TimeOut in SQLServer6.5?
4 replies
I am trying to write a stored procedure where i select a bacodeNo field from a table then convert t…
2 replies
There are 2 "tables" in the unidata db. Contractor_master(CM) and Contractor_Driver_Profile(CDP. I…
3 replies
1. What is the minimum role or permissions a sql user needs to execute DBCC FREEPROCCACHE? 2. How a…
2 replies
Is there another way to find the amount of space used in a datafile besides dbcc showfilestats? I …
10 replies
Hello experts, Can you please help me translate this sql statement into T-SQL? Thanks. First sql: …
4 replies
Viewing 15 topics - 280,591 through 280,605 (of 283,916 total)