Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL.
2002-02-27
12,264 reads
Is it possible to create a 'command' that will replace if exists (select * from sysobjects where id = object_id('usp_myproc')) begin drop procedure usp_myproc end create procedure usp_myproc with create or replace usp_myproc ... ? in which case I would like to know how? Best regards Henrik Staun Poulsen Stovi Software Denmark
2002-02-26
4 reads
I have users creating and running dts packages on my production SQL servers. Besides disabling the guest account, what other actions can I perform to prevent the creation and operation of unwanted packages.
2002-02-21
I wrote a DTS script that outputs a text file for a DOS program. Turns out, the DOS program couldn't read the file because it uses UNICODE character formatting! (Specs of DTS Box: Win 2K, Sql 7). Can DTS convert a UNICODE file to Ascii format? TIA, Bill
2002-02-21
16 reads
I would like to run a simple query to identify duplicate records in a table, in other words, something like a NOT DISTINCT keyword would be perfect. Any ideas ?
2002-02-21
3 reads
I'm using stored procedures xp_startmail, xp_sendmail and xp_stopmail to send emails from SQL server to different email addresses. Most of the time, every thing is Ok and emails are sent. But sometimes, i get following error .... ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is […]
2002-02-21
2 reads
Does any one know, how can I get the first day of some week. For instance, I want to know the first day of week "20" in year 2001. Any help I appreciate. WolfJr
2002-02-21
How i can get the number of time that a specific string appear in each register of my DB using T-SQL. These strings are in a field separated between then by white spaces and comma, ex.:" 001, 002, 003, 001, 007, 001, 002, etc"
2002-02-21
Bit frightening how many people are using maintenance plans. Guess that's why there are so many posts on various forums about them not working. And why there are so many posts about people not understanding basic maintenance on sql server.
2002-02-20
1 reads
In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.
2002-02-18
9,783 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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