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...
Thanks Satya the SP_HELPROTECT procedure is very interesting. I'm not looking for activity, rather priviledges for all accounts. So I started...
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...
I found a way around it, but it's quite involved and kind of ugly especially in long stored procedures<br /><br />OLD: select * from customers c,...
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...
In case someone else needs this, here is the solution: DECLARE @idoc int DECLARE @doc varchar(8000) Set @doc =...
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...
Ok seems like it's not possible to use an sp as a table even thought it returns a table dataset...OH well it sounded reasonable at least to me <img...
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....
Thanks for the leads. Unfortunately, most of the convertion software out there deals with Oracle databases, not dump files so it seems that I'm out...
I'm going to check out the toad software, thanks for the info. I contacted a dba with Oracle but I was told that without any information about the...
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...
Looks like I'm going to use a DTS pkg to call a batch file, since I'm much more familiar with that. Thanks eveyone for your feedback.
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...
I deleted all .trn files copied over to the secondary server and manually re-copied them from the primary server and now the restore job on the...
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...
Separate names with a comma.
