Allowing BULK INSERT for non-SysAdmin Users in SQL 7.0
One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.
One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.
This article examines how index statistics are used in SQL Server 6.5
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.
One of the most pain-staking tasks a developer and DBA must often accomplish is to create an install procedure for the database. This involves creating the necessary DDL to create the tables, relationships and indexes. Inevitably in this process you forget about the data. AutoInserts to the rescue!
Chances are, if you've dealt with any type of data, you know you
rarely receive the data in perfect condition. In this second article in the series on cleaning data, Brian Knight shows you how to scrub data with a more advanced method.
Microsoft has the #1 OLAP product according to a new survey from Survey.com
Microsoft has announced that it is now accepting applications for beta testers for the latest service pack.
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Comments posted to this topic are about the item Diving Deeper into the Import...
Hi all, I need a list of objects (DMV's and probably other objects) that...
Recently I got sql alerts from one of QA servers, every 2 or 3...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers