Matt Miller (4)

Forum Replies Created

Viewing 15 posts - 3,781 through 3,795 (of 6,486 total)

RE: Inserting rows into remote server with identity column

I don't believe that you can use the SET IDENTITY_INSERT outside of the database you're in. Sounds to me that you'd have to do all of this from within...

April 5, 2008 at 12:11 pm

#798811
RE: Update Query for multiple rows based on Multiple Criteria

Jeff Moden (4/5/2008)
Something is very wrong here... the original query posted by the OP works just fine.
Agreed - it seems that we never got to see the actual offending code....

April 5, 2008 at 11:57 am

#798809
RE: Source Tracking software

rbarryyoung (4/4/2008)
Also, I believe that Visual Studio Team Systems is integrated with SQL Server.
You mean VS TEam Suite for Database Pros? yes - very nice. I have had...

April 4, 2008 at 9:06 pm

#798761
RE: Source Tracking software

SourceSafe? we've been using that for a little while - works pretty well for our purposes....

April 4, 2008 at 8:14 pm

#798747
RE: Upgrading to 2005

Michael Earl (4/4/2008)
Plan a bit for the future also.
If you expect another 100 users over the next year, CAL licenses may be expensive.
Then again, if you have hardware upgrade plans...

April 4, 2008 at 2:21 pm

#798684
RE: Upgrading to 2005

While it never hurts to call one of the licensing specialists @ms to double-check, this may help you get a read from MS's "How to License SQL Server" document:
Sometimes organizations...

April 4, 2008 at 1:33 pm

#798662
RE: Update Query for multiple rows based on Multiple Criteria

lersner (4/4/2008)
Thanks.
How about if I want to do that for multiple records in one update statement. Will I need a loop or can I use an OR?
A single update query...

April 4, 2008 at 1:18 pm

#798654
RE: Installing SS2005 on laptop with Vista

GSquared - did you ever get SSRS to install on home premium? 'Cause no matter how I tried it, it just plain refused to even consider doing it. ...

April 4, 2008 at 12:36 pm

#798624
RE: What kind of DBA are you?

Mike Menser (4/4/2008)
Well, I made it known in the original post, that the SEQUEL way is the only way for me. Sorry. But to know that hall of famer Grant...

April 4, 2008 at 12:27 pm

#798621
RE: Can adding a new column cause the automatic creation of clustered index?

Michael Earl (4/4/2008)
In many cases, when you make a change to a table through Management Studio, the change is scripted as the creation of an entirely new table structure and...

April 4, 2008 at 9:55 am

#798553
RE: Can adding a new column cause the automatic creation of clustered index?

Well - just ran a little test to confirm, but it seems to me that most DDL changes (certainly adding or removing columns, or modifying from null to not null)...

April 4, 2008 at 9:32 am

#798536
RE: What kind of DBA are you?

Mike Menser (4/4/2008)
I was reading a database magazine this morning and it had an interesting question. They were going to take a poll to see which group of DBA's were...

April 4, 2008 at 9:07 am

#798511
RE: Update Query for multiple rows based on Multiple Criteria

What subquery? The code you posted doesn't have a sub-query, and an UPDATE statement cannot be a subquery.

April 4, 2008 at 9:00 am

#798506
RE: Best Way to write an Update Stored Procedure

The hidden assumption in the question seems to be "in a GUI situation". Meaning - how to write an update SP to be used in a GUI.
Given that -...

April 4, 2008 at 8:56 am

#798503
RE: IF (COLUMNS_UPDATED()) ???

Stephen Grimshaw (4/4/2008)
In Sybase T-SQL (where I spend most of my time) UPDATED simply means that the column has been specified in an UPDATE command. It does not mean that...

April 4, 2008 at 7:29 am

#798426

Viewing 15 posts - 3,781 through 3,795 (of 6,486 total)