I'm trying to parse xml that contains attributes which seems to be blowing up my code (sql 2k5 error:'XML parsing: ...undeclared prefix'), what am I...
Assuming that the stored procedure returns a simple dataset shouldn't something like this be possible? Select * from (exec sto_procedure) a Thx...
I needed to test something and set the max memory on the testing sql 2005 server to 10MB. Now the server won't accept connections to set the memory...
I renamed the production server hosting reporting services (which I don't use much) and I just tried to install sp2. The sp2 fails saying that I...
I received a large db from a client and it has lots of tables with defined relationships. When I pick the tables in the diagram they are linked for...
there is another post with this title but no resolution. I came across the same issue and I'd think I'm probably not alone, so anyone has a...
Since the *= and =* syntax has been deprecated in SQL2K5 I'm in the process of upgrading our current queries to the new standard. While a simple...
I'm having an issue pulling values from tags that have the same name as per below... This returns 2 values for customerID (GOOD!) Notice that it is...
Can it be done? I thought so... In other words if you have a stored procedure stoProc1 with NOCount set to ON that returns a table dataset for exa....
Hi everyone, I just received a .dmp oracle file from a client and I'd like to know if anyone knows of a way to import it into SQL. I do not have...
I'm new to the FTP functionality in DTS pkgs and my question is how do I set it up so that I can use the DTS pkg to SEND a file using FTP? I only...
error descr: "The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database." I noticed a similar...
I looked around but none of the suggestions worked so far. Here is my environment: SQL Server 2000 Sp3a Std Ed Win2003 box dbs with full-text...
Hello group, anyone had any experience with SMTP Mail Task (beta 1) http://www.sqldev.net/dts/SMTPTask.htm)? I took a quick look at it and it...
In SQL books online I read: ...tempdb holds all temporary tables and temporary stored procedures. It also fills any other temporary storage needs...
SQL Server 2000 Enterprise, Windows 2003 Enterprise with 8GB of ram. I read a bunch of articles on technet / sql books online / this site but I'm...
I have 2 servers with SQL 2000 sp3a on win2K. Due to the double hop issue with windows authentication, in the "linked server Properties" window in...
I need to backup all dbs on my sql development server. Yet I don't care for the data I just need the structure / store procedures / views etc... Is...
I have a very large DB and I want to track down the largest tables. Does anyone know which system table contains the info about table size in Bytes,...
Here is my task: Setup a server that allows developers to test their apps against a pretty realistic environment. I looked into log shipping but NO...
Separate names with a comma.
