Sync Users After SQL 6.5 DB Restore
I have quite a few users in a 6.5 Database. After restoring the db to a dev box, I wonder if there is an easy way to sync up the users. Thank you for your help.
2004-06-30
2 reads
Random Numbers
RE: Need help creating dynamic "USE" statement... Thanks.
Having fun with more dynamic dynamic sql DECLARE @stmt NCHAR(1000) SET @stmt = 'USE Frank_3 ' + CHAR(13) + 'DECLARE @stmt NCHAR(1000)' + CHAR(13) + 'SET @stmt = ''CREATE TABLE Second (col_a int)''' + CHAR (13) + 'EXEC sp_executesql @stmt' EXEC sp_executesql @stmt Do I need to add the reference to Erland Sommarskog again?
2004-04-28
2003-12-14
RE: Drill Through filter option
In the Cube Drillthrough Options screen, on the Columns tab, you should see all of the columns contained in all of the tables used in your model. Assuming you have only 2 tables, a fact and a single dimension, the columns may be something like COLUMN TABLE fkCol1 tblFact fact1 tblFact fact2 tblFact pkCol1 tblDim1 […]
2003-11-28
RE: Invalid column
quote: ...if you placed a GO between the Alter and the Select... True in this contrived example but not if the intention was to use it in a procedure.
2003-11-26
2 reads
RE: Error when changing startup account
the user that you want to change the sql service account need to be a user at a minimum at your local box. mom
2003-11-20
RE: procedure
Please don't crosspost. This is the other forum post: http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14456&FORUM_ID=23&CAT_ID=2&Topic_Title=procedure&Forum_Title=General
2003-07-25
RE: tracking updates on tables
quote: oh, and one more thing - (this is classic) - put in a trigger on the table that will randomly show managers making updates to different manager's data - that'll keep 'em busy... d*mn right. You know, yesterday we closed an options position with a loss of ~6 million €. Call it an insurance […]
2003-07-18
2003-07-16
RE: Triggers vs. Foreign-keys?
Did you see the SQLServer Community update for today? It was advertising Kim DeLaney's new book: Hands-On SQL Server 2000 : Troubleshooting Locking and Blocking Kind of ironic, don't you think? Sorry, just had to come back and share that. Hey, it's only $22. Might be a good investment.
2003-06-25
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers