Forum Replies Created
Viewing 15 posts - 37,771 through 37,785 (of 39,757 total)
-
RE: Understanding Your Identity
You are welcome. Check out DBCCCheckIdent. It will allow you to reseed the identity value (useful when trying to synch two servers), especially in a dev environment. It also lets...
-
RE: Triggers each row or not?
In SQL, the trigger fires once per transacitons. So if you have a multi-row update, you get one trigger firing. The inserted and deleted contain all the affected rows.
Steve Jones
-
RE: Telemarketing Revenge
Some good ideas. 🙂 Personally, I avoid the phone, though I think I'll start letting my 3yr old answer.
Steve Jones
-
RE: Understanding Your Identity
Wow, thanks for the responses and sorry for being so late in getting to them. Here's a few thoughts.
I got a message from one person expressing this was not a...
-
RE: TimeStamp displays "1900-01-01 00:15:24.437"
Not sure what you mean? What's in tabletest? You should get the datetimes from the table. Getdate is the server date. Not related.
Steve Jones
-
RE: How do access tables w/o owner prefix?
Agree with Antares. Avoid using owners other than dbo in SQL Server. Not sure about Oracle, but it's more headache than it's worth in SQL Server, IMHO.
Steve Jones
-
RE: Grant/revoke select, insert... across DBs
Just a thought. If you are doing this anyway, I'd create a view in each DB that points to the other db. Easier than rewriting lots of queries of the...
-
RE: MSSQL 6.5 server Crash
Glad we could help. Thanks for the followup, but pls post in the original thread.
Steve Jones
-
RE: Refresh development databases
If you read my series on Version Control, you will see that I have everything in flight. If a developer is testing something and hasn't scripted it or let me...
-
RE: MSSQL 6.5 server Crash
Yes and no. In v6.5, it is easier to work with the system tables, but it can be tricky. Is there a reason you don't do a restore?
You can...
-
RE: Coding Standards - Part 1
Not a bad idea. One I hadn't thought of, especially since most databases only have a single target app. Might be easier to find them that way, though they'd be...
-
RE: Coding Standards - Part 1
Views tend to be across tables, so a prefix doesn't matter. Personally, I like having the names of the objects associated with the table, next to the table in an...
-
RE: Images: Store in SQL2000 or on File Directory?
You msy indeed have to set it twice, but you only do that when you code. The time to set this in code is pretty small. You could also write...
Viewing 15 posts - 37,771 through 37,785 (of 39,757 total)