RE: Using the CASE syntax with GOTO
Solved it as follows: EXEC sp_executesql @SQL This will execute the user defined function. Thanks for your input DavidT.
2003-08-07
Partitioning
RE: Zipping solutions for db size of 5gb
I'd recommend WinRAR as well. It can handle HUGE DB sizes. I compressed a 100GB database (no free space) down to 6 GB using the normal compression rate with WinRAR.
2003-08-06
RE: Hotfixing MSDE and MDAC
It really depends on how secure your LAN is behind your firewall. As many organizations have found out a firewall doesn't protect you from: - VPN connections - If users are allowed to VPN into your network, any virus, worm, etc on their machine now has access to your LAN behind the firewall. - Laptops […]
2003-08-04
1 reads
RE: Alternatives to ms-access linked tables to SQL2000
Using Access you could build a small app with unbound forms. Create an insert, update and delete procedure in SQL Server. SAMS Microsoft Access Developer's Guide to SQL Server has examples of how to do this. If it was just a question of updating a table with known data, the simplest way would be to […]
2003-07-24
RE: Alternatives to ms-access linked tables to SQL2000
Anything with similar power will probably have similar liabilities. I'd recommend against Query Analyzer, for some reason users find it pretty daunting. When you say edit, is it just find a single row and edit, or they apply update queries? If the requirements are simple enough, you could throw together a small custom app that […]
2003-07-23
1 reads
RE: Using SQL Mail on a Clustered Server
quote: is probably more related to an inability to resolve email names than anything else. We see this on non-clustered environments. This is very true. We see it, too. Hence a switch to Perl, SMTP, and a job scheduler outside of SQL Server in our environment. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide […]
2003-07-23
1 reads
RE: Overall Scorecard ?
Hi there, as of this morning, a comparison between the rest and me is up. ...but I tell you, it is massively frustrating to see that I scored only 52 points compared to 52,104 which the other members scored Now being serious, I think a comparison on absolute numbers is not appropriate here. just my […]
2003-07-17
RE: Primary Key constraint
Another approach: INSERT INTO maintable(pk_field, field1, field2, etc...) SELECT s.pk_field, s.field1, s.field2, etc... FROM stagingtable s WHERE s.pk_field not in(SELECT pk_field FROM maintable m)
2003-07-10
2 reads
RE: Moving entire SQL content to new server.
I had same scenario of moving 8 databases from a SQL 7 server to a newly built SQL 7 server some time ago. I used the article Greg Larsen provided (246133) and it worked fantastic. Two additional articles that were of help are: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b314546 http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b240872 Both above articles have links to other MS articles that […]
2003-07-08
RE: CaseSensitive Select
Thank you for the reply. Since the input data is very limited and the first character is unique, the ASCII allowed for simply checking of upper/lower case. The problem is in the DTS Execute SQL Task. It apparently does not allow the use of any native SQL functions (ASCII, Convert, etc) in conjunction with an […]
2003-07-08
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