like brain donor's example, my two examples would involve a cursor to process the files after i got the list of files.

my example for xp_cmdshell is really similar:

--a table to...

for the operating system, i *think* it's 192 gig, based on this page:

http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#memory_limits

for SQL 2005, a lot of it depends on the AWE and PAE settings, since it's probably a...

well, you say you have foreign keys in place, so I'd start with any contraints that are disabled or not trusted:

SELECT

name,

is_disabled,

is_not_trusted

FROM sys.foreign_keys

WHERE...

ok i think i see it.

if you run my previous sample code, including the DROP DATABASE,a dn THEN run the code snippets below, you get a misleading message:

it's not maintaining...

Lynn Pettis (7/16/2012)

---

Lowell (7/16/2012)

---

both commands will work perfectly in SSMS;

are you running this through an ODBC driver, and the driver might be mis-translating the object names?

where is this code being...

both commands will work perfectly in SSMS;

are you running this through an ODBC driver, and the driver might be mis-translating the object names?

where is this code being executed?

something like this?

With MyCTE (#ID,RouteID,Seq,BuildingID,StreetName,StreetNr,StreetAddInfo)

AS

(

SELECT '01','D903010','0000','8912200','John Smith','103','13A' UNION ALL

SELECT '02','D321989','0000','7893738','Mary Clarkson','24','11A' UNION ALL

SELECT '03','D327298','0000','9436432','Cleveland','1134','72A' UNION ALL

SELECT '04','D327298','0000','9436432','Cleveland','1134','73A' UNION ALL

SELECT '05','D674748','0001','6355454','Christina Tyler','67','21B' UNION ALL

SELECT...

web page with a simple aspx grid, i would think.

easy to implement, no software to install.

but if soundex finds any number, or any non a-z,A-Z character, it returns something like "B000" (all zeros), so soundexing on addresses gets meaningless, since most addresses have numbers in...

it sounds like the promotion of a specific set of both database changes and application changes that would occur together, like when an application upgrades from version 1 to version...

Brandie Tarvin (7/16/2012)

---

I thought that was Bird Flu...

And Whatever ever happened to the killer bees that were supposed to kill everyone along the US border as they migrated north?

all my DDL triggers are designed as putting the EVENTDATA() into an xml variable, and then querying the xml variable; not a single one of my sample triggers seem to...

there's a nice anonymous Script submission someone put together to help document a database by generating an html document here on SQL Server Central

Comprehensive HTML Database Documentation [/url]

i enhanced...

that's going to be something you have to get with your exchange administrator to help with. it's not an issue with db_mail; you'll see the same behavior if you sent...