Forum Replies Created
Viewing 15 posts - 271 through 285 (of 289 total)
-
RE: Post Scripts
Ask and ye shall receive
. I kept the yard gnomes up late last night in the SQLServerCentral.com sweat shop. You'll notice a new Scripts... -
RE: Post Scripts
I have completed this section and will probably be online mid-this week. It just a matter of hammering out the last minute bugs
. ... -
RE: Encrypting Data With the Encrypt Function
quote:
Supposing im creating a personnel database and want to store national insurance numbers etc , i want this to be encrypted in... -
RE: Load Testing Database
It also comes with the SQL Server resources kit book. You can also use DataTech's product to load databases with meaningful data. I prefer it over the Quest...
-
RE: Active / Passive clustering
This will show you how to an Active/Active cluster.
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
To do an Active/Passive cluster, just stop at this paragraph:
quote:
After... -
RE: Estimating space usage
quote:
cool. I guess I need to get off my ass and read the manuals and use it 🙂July 18, 2001 at 5:44 am
-
RE: Using FTP in a DTS
Great question. This problem was resolved in Service Pack 1 for SQL Server 2000. Make sure you install it on the client executing the package as well. ...
-
RE: Estimating space usage
quote:
I've got ERwin and have no clue how to use it. I though it just did schema layouts easyer for you. -
RE: Estimating space usage
I'm working on an article next week about this actually. It'll be up on Monday. If you have a general idea about how many records you'll be receiving each...
-
RE: Encrypting Data With the Encrypt Function
quote:
Encrypt function in T-SQL is fine what about Decryption of encrytion columns.kindly tell us how to do it!
July 16, 2001 at 7:23 am
-
RE: Auto logoff of users
quote:
We have a data warehouse with olap cubes. We update the data nightly starting at 7pm-?. I would like to block the... -
RE: DTS Query using Global Variable
Are you using SQL Server 2000 or 7.0? There's a huge difference when you deal with this topic. This is a great question though and should be fun....
-
RE: Securing DTS packages
You may have read it from this tip:
http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp
You're right on with the stored procedures you need to deny. Of course, simply placing owner and user passwords will...
-
RE: Any better tools to develop packages (3rd pty)?
quote:
Are all of these codepage, locale ID, sorting differences transparent to DTS, or is that going to create any issues in actually... -
RE: Determining Standard or Enterprise Installed
I missed the second part of your question...sorry! You can do the upgrade to 2000. Just make sure you backup all the databases before the upgrade.
. I kept the yard gnomes up late last night in the SQLServerCentral.com sweat shop. You'll notice a new Scripts...
. ...Viewing 15 posts - 271 through 285 (of 289 total)