Viewing 15 posts - 36,631 through 36,645 (of 39,903 total)
Is there some reason you cannot break it into multiple steps? Seems like it would be good programming practice to do this anyway.
Then scheduled multiple steps.
Steve Jones
March 12, 2003 at 10:37 am
That basically means all the pages are contiguous in the system.
Steve Jones
March 12, 2003 at 10:04 am
THat's part of the forum code (Snitz) that we used. It doubles quotes for the inserts into the table to be sure they work. I suspect they forget to undouble...
March 12, 2003 at 9:26 am
Why can you not use the UPDATE() statement. I'd be really wary of having a trigger that did not know the columns of the table.
You can always get the columns...
March 11, 2003 at 9:45 am
tough questions, lots of responses.
Basically, identity is simpler, easier IMHO for humans to deal with. Less space. Not unique across servers. Can cause issues in replication.
GUID is harder to use...
March 11, 2003 at 9:42 am
Are you guys running a dedicated SAN for the database server? Or is it shared?
Wondering becauase we are getting a SAN to remove some file server storage and they are...
March 11, 2003 at 9:39 am
I believe any change to the login (new defaultdb, language, etc) will trigger a chance on xdate2. However, once the login is setup, it is unlikely that anything other than...
March 11, 2003 at 9:36 am
I've automated the sa change. As far as service accounts, I change those manually. Since I need to restart SQL, might as well watch each one.
As far as EM, up...
March 10, 2003 at 3:57 pm
This is an intersting question and one I may dive into with an article. Basically, I'd be watching for any error and resolving it or determing the cause. Most information...
March 10, 2003 at 10:08 am
I've gotten the 2K-2K to work, but not 7 to 2K.
The stored procedure is intended to move logins, not permissions, though I agree with you that adding permissions would be...
March 10, 2003 at 10:05 am
I had a meeting with the Litespeed guys and they are working on a GUI to go with their product. Expect to see pre-release (beta) code anyday.
I wouldn't let the...
March 8, 2003 at 9:59 pm
I have also used views for this.
use databaseB
create view TableInA
as
select a.*
from databaseA.dbo.TableA
Steve Jones
March 7, 2003 at 11:56 am
That thing is flaky. I'd not use it.
If you can afford downtime, right click the db, all tasks, detach db. Copy the mdf/ldf to the new server and then right...
March 7, 2003 at 11:53 am
Slight caveat.
You can run v6.5 as the first instance and 2000 as other instances.
It is in SQL Server 7.
Not sure you need separate IP addesses. Why not separate databases?
Not...
March 7, 2003 at 11:51 am
run sp_detach_db <db name) to detach the databases.
Then copy the .mdf and .ldf files to the new server and attach them.
http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp
Steve Jones
March 7, 2003 at 10:39 am
Viewing 15 posts - 36,631 through 36,645 (of 39,903 total)