Viewing 15 posts - 36,451 through 36,465 (of 39,720 total)
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
Test taking is always a double edged sword. The goal is to learn things, but if you don't pass the test, which is only pass/fail, you are stuck. It's time...
March 7, 2003 at 9:56 am
Not familiar with Filemaker either, however As Antares mentioned, I think you need to weigh the upgrade costs (software, time, development) and see. IF Filemaker isn't performing and something needs...
March 7, 2003 at 9:50 am
Glad to help. Threw me for awhile as well. just kept trying things.
Steve Jones
March 7, 2003 at 9:43 am
Viewing 15 posts - 36,451 through 36,465 (of 39,720 total)