Viewing 15 posts - 5,311 through 5,325 (of 7,429 total)
You may also want to consider using the vbscript based SELECT CASE statement as it is a bit cleaner and less code involved but produces the same results.
Function Main()
SELECT CASE...
June 25, 2002 at 5:44 pm
Just don't do the / 1024 part and will be KB.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 25, 2002 at 8:48 am
jcogle SPs should not be the general issue. SPs internal code is the only way this can be a problem. SPs offer lots of bennifits and I have heard of...
June 25, 2002 at 5:46 am
This will give you the physical file size but not used space.
SELECT (size * 8.0) / 1024 AS MBsize FROM sysfiles
or for total size
select (SUM(size) * 8.0) / 1024 AS...
June 25, 2002 at 5:43 am
From BOL
quote:
The user must have SELECT permissions to run the specified query and CREATE PROCEDURE permissions in the database in...
June 25, 2002 at 5:11 am
I believe you can do this with VBScript after you output the data to text file. Open in VBScript using FileSystemObject and TextStream (Lookup both at http://msdn.microsoft.com . You can...
June 25, 2002 at 5:07 am
ARe all the values for the column NULL? If so have you tried to transform the column by itself? Also is this column computed?
"Don't roll your eyes at me. I...
June 25, 2002 at 5:02 am
Yes it will prevent them. It is better to create put the users in the db_denydatawriter and db_datareader roles. Or create a single role with grant on SELECT and deny...
June 25, 2002 at 4:57 am
First what version of SQL are you using? What is the collation of the destination table column or database? If different then consider changing the format file to say the...
June 25, 2002 at 4:54 am
What version of each SQL Server are you running? If one is MSDE (Desktop Edition) then it does not support DTS but I thought you could use DTS from a...
June 25, 2002 at 4:43 am
Right click the databae in SQL 2000 in EM and choose properties. Verify on the General tab at the bottom that the collations for the database is the same. If...
June 25, 2002 at 4:39 am
By default a connections LOCK_TIMEOUT is -1 and you should not have to set. You best bet would be to use Profiler to monitor a process and see if anything...
June 25, 2002 at 4:29 am
DBCC CHECKDB to determine the extent of the damage.
Then you will need to correct the problem.
There is a chance you will lose data so hoepfully you have a pretty recent...
June 25, 2002 at 4:19 am
The objects themselves may not have the permission applied if the user objects have restrictions. db_denyreader & db_denywriter roles automatically prevent access. Another possible place is did anyone change the...
June 25, 2002 at 4:10 am
This is trying to stop SQLSERVERAGENT which means it must be running. Are you running a previous instance on the box in question or is this suppoossed to be...
June 25, 2002 at 4:08 am
Viewing 15 posts - 5,311 through 5,325 (of 7,429 total)