my sample data was all 6 characters;

this does the STUFF in reverse order, whhich would handle the 5 char times you are seeing sometimes.

select

[active_end_time],

REVERSE(STUFF(STUFF(REVERSE(convert(varchar,[active_end_time])),3,0,':'),6,0,':'))

+ CASE WHEN CONVERT(int,LEFT([active_end_time],2)) >...

David's got me thinking to day!

your time datatype error is because of SQL 2005, i assumed you wer ein 2008 because of the forum you picked.

this puts ont he AM/PM:

select...

stuff worked for me to convert it to an actual TIME datatype, but the AM/PM would be an extra step:

select

[active_end_time],

CONVERT(time,STUFF(STUFF(convert(varchar,[active_end_time]),3,0,':'),6,0,':') ) as val

from [msdb].[dbo].[sysschedules]

Jet-Ski (10/24/2012)

---

We actually had this just yesterday. Someone deleted 100 records from our CRM, told us about it 30 minutes later. We did a point in time restore, but lost...

the import/export wizard is just an application. once you have a user name/password so you can loginto SQL server, you can use...

excellent! I'm glad you found this thread and the helpful procedure!

in a bat/cmd file or command prompt, you can get the computer name from the variable %computername%

echo %computername%

so you can build a script with that...does that help?

edit

also, if...

well there is two pieces of the puzzle.

IF the linked server is using dynamic ports, you need to have the SQl Browser Service running on the linked server. If it's...

a post here on SSC says one person thinks that error is related to this:

http://www.sqlservercentral.com/Forums/FindPost1168084.aspx

The first error message actually looks a lot like the dynamic packet sizing (autotuning) in Windows...

you could build the queries you want to execute for all tables meeting your criteria.

if the table has a value in the UpdateBy column, are you trying to set...

the error is pretty straight forward; it could not find the table in the database. maybe when you abstracted it out, you hid the issue.

do you Really have a database...

sp_trace_getdata is used by SQL Profiler to read it's trace and return the results to the SQL Profiler GUI/application;

SQL Profiler is definitely known to have an impact on SQL server...it...

Sreejith Sreedharan (10/23/2012)

---

Thanks for the email. Based on my searches thats what I came across too. Do you know of any one who has created this as CLR function? May...

Looks like you'll have to use a CLR routine.

i grabbed this function in vb.net from Google, you'd have to convert it to a CLR function from there.

source:http://stackoverflow.com/questions/7515164/visual-basic-2010-hmac-sha1

edit: here's the converted...

Sreejith Sreedharan (10/23/2012)

---

Has any one encrypted data using HMAC-SHA1 or HMAC-SHA256 encryption method. I need this done for the current project that I am working and am unable to find...