Viewing 14 posts - 1 through 14 (of 14 total)
ok.. that is what I was afraid of. I have wracked my brain trying to think of another way to write it that did not involve dynamic SQL,
FYI.. here is...
January 30, 2023 at 4:35 pm
No, the XML can be for different columns of different tables…, But generally in the same format with the same root and row tags
January 30, 2023 at 4:23 pm
Yeah, I caught it too and fixed it.
The output of the query is
ExtPmtSchedID NextPmtDt ProcessingStatus
1734603 2023-02-10 07:00:00.000 NULL
The table is ExtPmtScheduling
CREATE TABLE ExtPmtScheduling (ExtPmtSchedId INT IDENTITY(1,1) PRIMARY...
January 30, 2023 at 3:24 pm
I shut down management studio, then reopened it so that it would start at the beginning of the list to poll for service status on the remote db. I...
March 25, 2011 at 12:11 pm
I performed the subinacl command. here are the results where ****** is substituted for my actual domain name. Am I not running the command correctly? Also, I have...
March 25, 2011 at 11:59 am
When on the server itself, the status icon displays properly and I can control the SQL service when on the box.
When on the main management db server under...
March 25, 2011 at 11:18 am
We use VM templates for our SQL servers, so all servers are set up identical (all 78 that I manage). All are configured with default SQL configurations regarding the...
March 25, 2011 at 11:16 am
I use windows authentication and I am a domain administrator. My domain account also has sysadmin privileges on SQL server given that I am the DBA.
I can...
March 25, 2011 at 11:12 am
Back on topic... I received confirmation from my network engineer that 1434 TCP/UDP bidirectional is open, so I should be seeing the status indicator of my servers turn to a...
March 25, 2011 at 10:54 am
I know this is an old post, but has this changed? I have not read anything on it. In most languages you have an Exception and an inner...
May 13, 2010 at 1:40 pm
I'm going to go off on a limb and say that I thought the stored proc was a dll file. Well, it isn't and I opened it up. ...
October 26, 2009 at 9:45 am
That must be why it is undocumented. haha thanks for your help.
Moderator, could you please move this topic to the correct forum for sql2005? My apologies on the...
October 26, 2009 at 9:13 am
That worked! I replaced my code with your code that removed the begin and end within the conditionals and replaced the testingarea database name with my original.
I always try...
October 26, 2009 at 8:48 am
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build...
October 26, 2009 at 8:26 am
Viewing 14 posts - 1 through 14 (of 14 total)