Viewing 15 posts - 5,356 through 5,370 (of 6,105 total)
There is an undocumented command, DBCC LOG(), which will return some information.
Alexander Chigrik explains the command in a little detail in his article on undocumented DBCC commands:
K. Brian Kelley
July 9, 2002 at 3:34 pm
Glad you found a workaround, though it is illogical, but totally Microsoft. Visual Studio I don't believe has the capability to debug crash dumps. That's where the debugging tools come...
July 9, 2002 at 1:49 pm
Try the following link. It's to BOL at the MSDN site, topic of CAST and CONVERT. This gives all the formats for CONVERT.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp
K. Brian Kelley
July 9, 2002 at 1:45 pm
User-defined database roles can be nested. This means you can create your role and then make that role a member of other roles, to include fixed database roles. For instance:
July 9, 2002 at 10:43 am
Check the sysmessages table. For instance:
SELECT *
FROM sysmessages
WHERE error = 50000
K. Brian Kelley
July 9, 2002 at 10:35 am
Where is the SQL Server in reference to the client? Same box? Same LAN?
K. Brian Kelley
July 9, 2002 at 8:20 am
Try this:
DELETE tSchedule
FROM tSchedule s
INNER JOIN tSchDoneTemp d
ON s.SDG=d.SDG
AND s.Method=d.Method
...
July 5, 2002 at 10:15 pm
Is there an application dump file? Typically it shows up under C:\Documents and Settings\All Users\Documents\DrWatson\ if an application dump file was created.
This isn't always the location. To verify where Dr....
July 5, 2002 at 4:12 pm
I'm guessing you are using Windows authentication to login via Query Analyzer, right? Is your login to the workstation and the SQL Server on the same domain, or on two...
July 3, 2002 at 7:29 pm
I really enjoyed this article as it is filled with great practical advice. It's going to be a link I'm going to forward to all our development groups.
I tend to...
July 3, 2002 at 7:24 pm
Agreed.
EM is going to throw a larger net around things than we would to catch all possibilities since it has to. If we were to write it ourselves, we...
July 3, 2002 at 5:52 pm
sp_dropuser will drop for a user account for the current database only. You could write a cursor which retrieves a list of all user accounts except dbo and then use...
July 3, 2002 at 5:48 pm
It's in Query Analyzer through the Object Browser. Here's how to find it:
http://www.sqlservercentral.com/columnists/bkelley/qa2k_2_2.asp?Tab=2
One thing I haven't had time to do is figure out why it works for some people and...
July 3, 2002 at 5:45 pm
Profiler will capture all this information. Save the information to a trace file. Then, in order to analyze it, open up your trace file and save it to a...
July 3, 2002 at 2:32 pm
You may need to do a Profiler trace and look at T-SQL statement starting/completing to see if for some reason you are navigating those paths.
K. Brian Kelley
July 3, 2002 at 2:28 pm
Viewing 15 posts - 5,356 through 5,370 (of 6,105 total)