Create a user-defined database role for the appropriate database. You can do so in Enterprise Manager or through Query Analyzer. If using QA, you'll want to execute the following (make sure you are in the correct database): EXEC sp_addrole 'rolename' As far as granting that role the correct permissions, the easiest way to do so […]
2004-10-11
Hi,Thanks for you reply. I am going to face an interview for SQL SERVER DBA position. Thanks.
2004-10-11
Yeah, there's no way to do it directly. I've discovered that Visio Professional, has a nice database reverse engineering wizard. It seems to do a better job at database diagrams than the one included in Enterprise Manager.
2004-10-11
Hi,I am probably going to ask a dippy question here, but i still would like to know the answer !! I have a Server running Small Business Server 2003.On this server i have installed SQL Server 2000 with 10 licences (Courtesy of MS Action Pack!).I have written a VB6 package that connects to the SQL […]
2004-10-07
1 reads
I need to be able to set the DTSDestination column dynamically using a variable for the column name. Here is the code I am using: strColName = cstr(DTSSource("ColName")) DTSDestination(strColName ) = DTSSource("QVal") I am getting the error "Invalid procedure call or argument: 'DTSDestination'". I'm sure that I am just missing something.Thanks!
2004-10-04
3 reads
What is the difference between the SQL Agent Startup account (Agent...Properties...General tab) and the SQL Server Connection account (Agent...properties...Connection tab)I have always assumed that the Agent Startup Account is used when running scheduled DTS packages, replication etc. but don't know what the connection account is used for.Can anyone provide me with 2 scenarios one that […]
2004-09-08
2 reads
2004-09-07
HiIn a new system we are designing, we are considering using parent-child tables to maintain dimension hierarchy data. From these. AS can easily create parent-child dimensions in our MOLAP cubes, but a consultant has said that when processed, no aggregations will be held for the parent-child dimensions.I have tried to find documentation on this but […]
2004-09-07
1 reads
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginModeHonest mistake, but I want my honestly earned points back please.
2004-08-25
Fantastic, a conversation about grammar Sorry fhanlon, but going back to the Dictionary.com reference, if you follow the link for "Usage Note" to the definition for 'affect', you get to this: "Usage Note: Affect and effect have no senses in common. As a verb affect is most commonly used in the sense of “to influence” […]
2004-08-23
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers