Search results for query: *

I have a sp which populates a table. the SP resides on the same server/db as the table. Several of the values are assigned nulls and then inserted into the table. I have 4 defaults on some of these fields. However, instead of loading the default it puts a blank. ANy ideas

Not a true one to mimic, small one to test that it works correctly

We have a server (win 2003 sql server 2000) which had the latest MS patches applied on 3/23. The db server is a dell quad attached to a dell storage array. Ever since this patch we have noticed considerable slowdown in performance. Nothing much has changed as far as the db is convcerned...

Looking at below, it does not error out but also does not return what we are expecting form_ind = case when (select count(*) from fdb_medication fm1 where fm1.gcn in (select distinct fm2.gcn from medication_payer_mstr mpm inner join fdb_medication...

I have sql 2000 Ent running on Win 2003. My Cache hit ratio is running around 66%. TIme for more memory. Also, is there a way to show what specific objects are chewing up memory? This is 3rd party apps so changing app not an option

Anyone had any good experiences with SQL 2005 training with Clusters. I am in St. Louis, and training for this is a little thin. I thought there was some in Colorado or Chicago

I have 2 fields one with date like below, other is time like below but no milliseconds. Other than manully adding in all / and : is there a faster convert to combine the 2 for date/time comparison date time 20060303 150000 20070601 120000

MRDenny and one above are both right. Been living with log shipping for 8 years. Do not rename the server

Anyone had any luck with 3rd party vendors going from sql 2005 to Oracle 9. I have heard some of the 3rd part offerings are much faster than the MS or Oralce solutions

I will refrain for exlaining to my children to pay attention to detail when doing homework. Dad the DBA, did not pay attention the field specs in the table DTS created. Changed it from char to varchar and ran my first statement and it worked. Will now consider applying for Homer Simpson's job...

I have some data loaded from a mainframe looks like below lastname firstname id smith john 12 moris cal 13 The problem is there are what I thought were white spaces at the end of the names. I tried below on test table and with...

That's what I figured, kind of suprised MS didn't add that to the system sp, if it fails you are out of luck

Sorry, now have more info from developer. What they are doing is parsing through records and validating xml using system sp. As an example below. Problem is when invalid xml comes through you get system error, which you can correct me on, you really can't trap alter procedure tim as DECLARE...

If I have stored proc A which sends a value to be processed by stored proc B, but stored proc b errors out. If I have stored proc B return on error, is the @@error available for Stored proc A, or is the scope limited to B?

I thought you could but I have concerns. One application, all db's doing different function. The problem is that on the active/active there will be a db that the oltp is on. The other db server would be a logging server, which does and audit log of each transaction. The other db server is a...

We have a 3rd pary app coming in that needs to run on several sql 2005 Servers. Our network ops wants to run one active/active cluster and then another instance of sql 2005 on the same box. I didn't think this was possible? Any opinions appreciated

Actually it is a job that calls this sp for processing, you are right under 2005 much easier to trap

Tried this, but it returns a system error message declare @error int exec sp_xml_removedocument @hdoc SELECT @Error = @@Error IF @Error <> 0 BEGIN print 'to' end

One more question. It works great if a tag is missing. What if they just botch the xml say with a beginning tag, that is missing the end tag

Thanks, exactly what I was looking for