Viewing 15 posts - 23,071 through 23,085 (of 39,821 total)
The timestamp column isn't there to be a unique identifier. It's a versioning stamp in the database that some applications use to determine if something has changed in the row.
As...
July 18, 2009 at 9:59 am
Please don't cross post.
Closed thread. Answer here: http://www.sqlservercentral.com/Forums/Topic755298-149-1.aspx
July 18, 2009 at 9:56 am
Do you mean solo contractor? I haven't seen a lot written from the IT perspective. Have you ever contracted for someone? Meaning working for a consulting company? I'd say that...
July 18, 2009 at 9:55 am
It's not scalable for sure.
You are trying to keep in sync surrogate values that are acting as primary keys. However you are not generating them with in any realistic way....
July 17, 2009 at 2:48 pm
For now I would set the model DB to the simple recovery mode and read only. Something will start throwing errors when it can't write to the database.
July 17, 2009 at 2:42 pm
What you probably want for complex lookups is an SSIS package that moves data from server A-> B. Then another package to move from B->A. However you'll need to somehow...
July 17, 2009 at 1:37 pm
I think you are missing files or the download was corrupt. There isn't much we're going to be able to do if you don't have a good download.
July 17, 2009 at 12:42 pm
You can write a query or view to change data around and handle some simple transformations.
Without knowing more about what you mean, it's hard to recommend something.
I think anything you...
July 17, 2009 at 12:40 pm
Replication will do this, and you can transform the data somewhat on either side.
July 17, 2009 at 11:38 am
I think you're stuck with uninstall/reinstall.
July 17, 2009 at 11:33 am
There are a few blog applications out there, like .Text from Microsoft that you can download and examine the schema.
July 17, 2009 at 11:19 am
Can't be done.
Detach dbs, script logins, uninstall, reinstall.
July 17, 2009 at 11:18 am
This doesn't really matter, as long as you have the paper to support what you are running.
If you are doing this because you need to move the CPU license to...
July 17, 2009 at 11:18 am
There are multiple versions now, a light version (LT) that's smaller, a datawarehouse version, the regular one, etc.
July 17, 2009 at 11:16 am
Do it for one server, then build a set of scripts to pull this together. It sounds like busy work, since this is just documentation and the location can change...
July 17, 2009 at 11:15 am
Viewing 15 posts - 23,071 through 23,085 (of 39,821 total)