Viewing 15 posts - 3,241 through 3,255 (of 3,641 total)
I take it you have some performance problems?
If your staging and production database are on the same box then I would use one of the methods you mention.
If the two...
May 18, 2004 at 1:52 am
We have just had our first contract tester and I have to say that it has been a very positive experience.
Our QA environment highlighted the need for a change in...
May 17, 2004 at 12:39 pm
If you can login to one server with the SA password then you can hack into any other SQL Server on the network.
Try sp_addlinkedserver!
Because SA always has id 1 you...
May 13, 2004 at 8:06 am
In the majority of cases it works. In the past year it has failed 15 times on scheduled runs.
It is more the fact that I cannot get any diagnostic information...
May 13, 2004 at 7:57 am
NORMALISATION
Normalise when it is practical to do so. If you have a sales by day of week arrangement then there would be little point in normalising it down to a...
May 13, 2004 at 7:52 am
If the DTS hangs when running within Enterprise Manager then because the display is modal I cannot get to the current activity.
Taskmanager shows 100% CPU utilisation with the sqlserv process...
May 13, 2004 at 7:22 am
Basically I created the DTS package using the export data wizard then changed all the "CREATE TABLE" SQL tasks to "DELETE FROM" tasks.
There are twelve database tables. The wizard creates...
May 13, 2004 at 6:55 am
Try updating dtproperties.
If you have the "allow changes to system tables" disabled then, if it is truly a system table, it should give an error message.
It doesn't so it isn't.
May 12, 2004 at 8:12 am
BOL says that xtype='U' or type='U' means user table.
The fact that dtProperties is conceptually a system table even though it marked as a user table is neither here nor there.
It...
May 12, 2004 at 7:26 am
I think the dtproperties table thing is a bug in SQL Server because it is flagged internally as a user table.
To get around it you have to add and OBJECTPROPERTY(id,'IsMSShipped')=0...
May 12, 2004 at 4:19 am
I use something similar when assigning rights to stored procedures, but without the cursor.
I know that this is only an example question but for the scenario listed
a) I would probably...
May 12, 2004 at 1:38 am
There are several sorts of test.
May 10, 2004 at 5:50 am
It is a BIT field test.
The & means BIT...
May 10, 2004 at 5:43 am
I would be curious to know where Sybase ranks along side SQL Server, ORACLE, DB2 etc.
I have colleagues who are using Sybase on a particular project and because both SQL...
April 30, 2004 at 7:46 am
Viewing 15 posts - 3,241 through 3,255 (of 3,641 total)