Search results for query: *

We're starting to see customers who have FC SANs but I'm getting the idea that some of them really don't understand very well what they're good at and what they're not. We're seeing them take our database apps and configure the data drives to be on the SAN-- but that means a lot of little disk...

Am working with a warehousing installation that nightly imports a massive amount of data. Before the import, indexes are dropped and afterwards, the indexes are regenerated. The "create index" steps are now being multithreaded-- distributed over several threads. However, I'm finding in cases...

Yeah, shortly after I posted the message I thought about that-- and by setting a string variable to the CREATE LOGIN and using EXECUTE to run it I can get around the problem. Kludgy but it works and I don't need to support two scripts. Thanks....

I get the impression that osql (or somewhere in the sql processing) precompiles the entire script before it executes anything. In particular, this is a problem because it means you can't use IF statements to bracket new features in a script designed to be run on both old and new versions of SQL...

AAAAARRRRRRGGGGGHHHHHH!!!!! Found the answer: Looks like they changed the interface somewhat, and it wasn't easy to determine that-- the bcp_bind example was for SQL Server 2000, and it hasn't been updated for SQL Server 2005. Apparently, "sqlfront.h" and "sqldb.h" no longer exist. The old...

Learned a little more. Looks like the includes I need are supposed to be in Program Files/Microsoft SQL Server/80/Tools/DevTools. Or perhaps Program Files/Microsoft SQL Server/90/Tools/Devtools. So I uninstalled all of SQL Server 2005 (developer edition) and reinstalled it from scratch. I...

I saw a ref to this elsewhere but the link it pointed to had a disclaimer about obsolete stuff and I couldn't see a download hook. This probably is pretty old but I might try it. What I'm going to do first though is do a thorough search of the distribution media to see if it's hiding in a cab...

This may be crossposted to some other forums out of sheer desperation... Been working in Visual Studio 2005 and got to the point where I needed to build a native program that interfaces with SQL Server via the bulk copy API. So, I d/l'ed SQL Server 2005, installed it and tried a simple example...