Viewing 15 posts - 32,416 through 32,430 (of 39,744 total)
The above advice is good and you should be able to use those ideas.
What you want to do is gather as many examples of your addresses that need splitting...
March 21, 2007 at 9:24 am
I'm not entirely sure what's wrong, but I'd suggest running a trace when you access the job list in EM and one when your assistant does and compare them. Likely...
March 21, 2007 at 9:22 am
Thanks for the update. I'd really rebuild all indexes and then see. Also let us know.
March 21, 2007 at 9:16 am
Use PATINDEX or CHARINDEX to find the "". You can then use SUBSTRING to remove the middle piece.
http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp
http://www.sqlservercentral.com/columnists/sjones/20010424135929_1.asp
March 21, 2007 at 9:05 am
Mike,
good luck and hope it's not too late a night for you.
March 20, 2007 at 11:23 am
You need a trigger to record the time and then a field or table to store the data in.
http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart2.asp
March 20, 2007 at 8:02 am
Don't do this in a trigger. It's a bad use of triggers and can pause or hang the db. Use a trigger to log the event in a table. Then...
March 20, 2007 at 7:58 am
Use a script:
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=71
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1162
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1161
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1843
March 20, 2007 at 7:57 am
Are you sure that the NDF is just indexes? NDF files are just additional data files, which can store indexes or data.
Since this is for compliance, I'd think about getting...
March 20, 2007 at 7:56 am
The package is a binary object. It is stored as such. If you want the package documented internally, add an Active X task, and type in the documentation as a...
March 20, 2007 at 7:51 am
You can use DATEDIFF to calculate time intervals. Look it up in BOL for the parameters for minutes and ordering of the dates.
You could use an insert select() where your...
March 20, 2007 at 7:48 am
May work differently in SQL Server 2005. Sorry, in the middle of a workstation switch and ss2k5 isnt set up yet ![]()
You might be...
March 20, 2007 at 7:43 am
How are you doing the restore? Through EM or isql/osql or QA? EM opens multiple connections. The QA Object Browser opens a separate connection.
March 20, 2007 at 7:40 am
Not the max
. Might be less for some editions, but the max is the max for all versions.
March 20, 2007 at 7:13 am
Viewing 15 posts - 32,416 through 32,430 (of 39,744 total)