Search results for query: *

Well that is just misguided on Microsoft's part. With all their people working on hi-tech issues, the least they could have done in 5 years was made that work. I feel like I have a new car, but need to keep my old one to listen to the radio. I looked over just about every doc in BOL related to...

I am not able to register to AS2000 servers using the new SQL Server Management Studio that comes with SQL Server 2005. I'm in the Analysis Services area, but when I try to register to the AS2000 server, it says it doesn't exist. I can, however, register to these servers using the SQL Server...

Running Denny's code is what I was looking for. Thanks to both of you, George and Denny, for you help!!

Thanks George, but I'm not doing that for any individual database. I can do an sp_helpdb <dbname> for that. What I'm looking for is a way to query the default data directory and the default log directory that SQL Server uses to assign database files upon creation. Right now, I can only do that...

Is there a way through Query Analyzer, via an sp_xxx, or other method, of determining what the default database file and database transaction log directories are? Right now, I go through Enterprise Manager, and look at the database settings tab for server properties. Thanks, Doug

Excellent catch. Thank you very much.

I created a new stored procedure and a new trigger (see below). It will send an email when a record is inserted into a table (T_DUEDATE_EXTENSIONS). When I run the stored procedure by itself, hard coding my own values, it works fine. However, when I use the trigger and pass the variable, I get...

Thanks ... the problem was that the default client install for the Oracle 64 bit did not have the ole db and odbc drivers. Go figure ... after installing those on the server, it worked just fine. Doug

You can run this in a QA session on the server that your datbase is running on. This is a server configuration setting, and not database specific ... give it a try. Note that the size parameter is adjustable to fit your specific needs. You can set it to what you feel is appropriate. Doug

This will correct your problem ... check out BOL. sp_configure 'max text repl size','393216' go reconfigure with override

Has anyone linked a SQL Server 64 bit database to an Oracle database? I installed the Oracle client software for Windows 2003 64-Bit successfully, but since the current version of SQL 2000 for 64-bit does not use an on server Enterprise Manager, I'm using my 32-bit client PC to manage it, and...

I figured it out ... xp_loginconfig 'audit level'

How much memory, how many CPU's, and what is their speed, and what type of disk subsystem are you using? If you run the query immediately after runnihg it for a second try, does the query take the same amount of time to run the second time? I'm thinking your server just may not be up to snuff...

Is there a way to check, other than using the Enterprise GUI, to see what the security audit level setting is (ALL, NONE, FAILURE, SUCCESS)? I tried sp_configure, and these are not listed in there, even in the advanced options.

J ... I'm writing this as part of a script, and therefore cannot use enterprise Manager, which makes it easy. The file is the output of a dos DIR command, piped to a text file, so I'm not sure how the delimited state is, but I don't think it is straight tab delimited.

I have a table schema as follows: field1 datetime field2 float field3 varchar(50) I am attempting to import a text file, with records in the following layout. Here's a sample record: 11/16/2003 12:10a 146,944 log_dump.11160010 I've tried using BULK INSERT, but each time, it...

This definately points me in the right direction. Thank you very much.

Is there a way to convert the following eight character string into a valid SQL Server date field? I am assuming the year is 2003. 10260010 10 is the month 26 is the day 0010 is the time in military format (in this example, 10 miniutes after midnight) Thanks ...

The original data contains the title, like I listed below, but I'm looking for a way to just output the first occurance of the title. Title Name ----- -------- MR Jones MR Smith MR Brown MS Jones MS...

How can I write a query that hides duplicates in a column, but displays the rest of the row like: Title Name ----- -------- MR Jones Smith Brown MS Jones Smith...