the UPPER function is what you want in the query, or you can format it in the report side of things with the UCASE or .ToUpper function;

similarly, there is a...

it's not clear what you are asking...why would i want to update "mick"s balance with the information from "Jack"? for example? I'm sure that's not what you meant, but you...

i wouldn't be fixated on having a primary key just for the sake of having a primary key;

if you will be searching by [logtime] date primarily , i would simply...

you replaced "D" with a space.

repalce with an empty string instead:

select LTRIM(REPLACE(A_H, 'D', '')) from tableA

if you search the forums here, there is a function "dbo.StripnonNumeric" that could help as well;

also take a look at the two articles here on SQL Server Central;

they list a lot of free tools, some of which are related to monitoring:

Free Tools for the SQL...

julien.dutel (7/6/2012)

---

Thanks Lowell! Actually it generate the statement very-well. I was looking for a code that directly give me the desired dataset, is there a way to execute a string...

this will generate the statements so you can copy and paste them with just a little bit of cleanup:

SELECT

'SELECT Signal_Index, Sample_TDate_' + convert(varchar,N) + ', Sample_Value_' + convert(varchar,N) + '...

by default, a linked server will only show the objects available in the DEFAULT DATABASE of the loginthat is connecting;

That's important, because if you have a login 'bob' that has...

to get just the existing procs, you want to use the sys tables to help generate the commands you need:

SELECT

'GRANT ALTER ON ' + schema_name(schema_id) + '.' + quotename(name)...

Kenneth.Fisher (7/6/2012)

---

I'm trying to create a role to give to developers to edit stored procedures. I've granted it CREATE PROCEDURE at the database level but the user is still...

I purchased the SSMS Addin from The same company BrainDonor mentioned;

$50 bucks, and I went for the add-In vs the batch processing executable, as my coding is more...

print your @tableHTML variable before you get to the sp_sendmail.

is it null, maybe due to concatination? that would make your html body blank for sure.

check your one parameter and three...

this was an interesting article on setting custom file attributes;

http://blog.rodhowarth.com/2008/06/how-to-set-custom-attributes-file.html

i found it interesting that you can set attributes on non- MS Office files, and the attribute stays as long as...

most likely permissions.

The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives and folders,xp_cmdshell,bcp with a "trusted" connection, sp_OA type functions...