Viewing 15 posts - 2,881 through 2,895 (of 7,429 total)
There are several ways to do this. Most folks will just create a temp table with an IDENTITY column and insert the data, or add an IDENTITY column to the...
June 3, 2003 at 3:59 am
quote:
Does the Index Tuning wixard effect performance whilst you are running it? or should I wait until out of hours to run...
June 3, 2003 at 3:53 am
The link to that if anyone is intereted is http://www.microsoft.com/sql/evaluation/bi/reportingservices.asp%5B/url
also for those of you interested in how to get on a beta here is the message on the MS site...
June 3, 2003 at 3:26 am
I would press the fact that you pay for complete service and they are not providing such. But check your contract from when you setup, if it fails to mention...
June 2, 2003 at 5:05 pm
Couple of comments
1) JAVA is designed to eliminate as many securiy risks as possible. Amoung them is stealling focus, unless has changed it never worked (at least not right). Drawing...
June 2, 2003 at 5:08 am
There were some statements that things had been removed from the MDAC that I don't recall. I would try to get a machine on MDAC 2.1 to see but other...
May 31, 2003 at 12:53 pm
Run sp_who in QA then click in the result window and use find. Find is based on which section has focus, so as long as your cursor is in the...
May 31, 2003 at 12:52 pm
Is the SQL built dynamically?
May 30, 2003 at 11:00 am
Usually this is a font issue (missing or non-matching type). Run a test and see if it can properly validate the right info.
May 30, 2003 at 10:59 am
No, it requires the DB engine to be installed and listening to be infected.
May 30, 2003 at 10:08 am
From SQL BOL
quote:
sp_lockReports information about locks.
Syntax
sp_lock [[@spid1 =] 'spid1'] [,[@spid2 =] 'spid2']
Arguments
[@spid1 =] 'spid1'
Is the Microsoft® SQL Server™ process ID number from...
May 30, 2003 at 8:58 am
Yes, it means someone or some thing has connected to the Model database. The Model database is what is used as a template for all databases.
You can use sp_who or...
May 30, 2003 at 7:36 am
It could be the locking level. Look at the lock that is in effect to see what type of lock it is when occurrs. The query engine may have decided...
May 30, 2003 at 4:41 am
Are you saying you need to change the port your SQL Server is running on?
If so then open
Server Network Utility
you will find the configuration is best handled under there....
May 30, 2003 at 4:39 am
Viewing 15 posts - 2,881 through 2,895 (of 7,429 total)