Viewing 15 posts - 3,946 through 3,960 (of 7,168 total)
Welsh Corgi (5/29/2012)
I opened the XML File in SSMS but it was one line.
Press Ctrl+K+D to reformat the XML into something more readable.
May 29, 2012 at 9:51 am
Look into DT_NTEXT.
May 29, 2012 at 9:32 am
TCP Port 1434 is typically used by the Dedicated Administrator Connection.
UDP Port 1434 is typically used by the SQL Browser Service.
May 29, 2012 at 9:25 am
The fact that the two servers are in different domains is only relevant if you want to use NT Authentication to fire off usp_B using a Linked Server.
If you have...
May 29, 2012 at 9:02 am
TrimEnd accepts a char array, not a string. This is a more explicit way to write the code:
[char[]]$charArray = @('_','D','a','t','a','.','m','d','f')
"ccra_Data.mdf".TrimEnd($charArray) #1
"ccrb_Data.mdf".TrimEnd($charArray) #2
"Project_Data.mdf".TrimEnd($charArray) #3
"Projecs_Data.mdf".TrimEnd($charArray) #4
Notice the letters I bolded above are...
May 29, 2012 at 8:59 am
Uripedes Pants (5/25/2012)
Just before you replied the lightbulb over my head fired off. I noticed in the output from the package the FEL throws a...
May 25, 2012 at 11:00 am
borislava99 (5/25/2012)
Would it be better to use ?IF @ObjectDB='myDB'
BEGIN
USE MyDB
END
Msg 154, Level 15, State 1, Procedure TestProc, Line 4
a USE database statement is not allowed in a procedure, function or...
May 25, 2012 at 10:32 am
DO you have any non-default settings setup on the OLE DB Destination, e.g. "Ignore Failure" in the "Error Output" page?
May 25, 2012 at 9:45 am
Please read the section titled "Writing to the Windows Security Log"
May 25, 2012 at 9:39 am
thunderousity (5/25/2012)
Product Version: 9.00.4309.00
Product Level: SP3
Physical Memory_MB: 8184
min server memory (GB): 2.00
max server memory (GB) 4.00
VAS_GB: 2.00
awe enabled: 0
Looks like I am at a sufficient version SQL Server...
May 25, 2012 at 9:30 am
N.D (5/25/2012)
To clarify, it's the non-custom messages I'm trying to get to write to the log, eg - a 9002 log full event without having to force the log...
May 25, 2012 at 7:41 am
Abrar Ahmad_ (5/24/2012)
ivycool2012 (5/24/2012)
Without more detail it's going to be hard to provide any guidance.
[font="Verdana"]
We dump data in history tables via triggers etc logic in...
May 25, 2012 at 7:36 am
Just to add to what Steve said, you can see which system errors are automatically logged:
SELECT *
FROM sys.messages
WHERE is_event_logged = 1
...
May 24, 2012 at 5:40 pm
Hi again Kevin 🙂
Since you are mapping a variable in your FEL you can use an expression in a precedence constraint to check if the variable was set to something...
May 24, 2012 at 5:16 pm
I see. In that case I think the solution will require dynamic sql. Here is a start to help you get your column names. From here you can build a...
May 24, 2012 at 4:45 pm
Viewing 15 posts - 3,946 through 3,960 (of 7,168 total)