the problem is unless you have your own SMS service, you can't do SMs messages to cell phones;

while every carrier has a supprt email that allows an email to be...

it's fairly straightforward;

the OBJECT:: does not allow a variable name i think. as a result, you just have to use dynamic sql to do the same job.

declare @sql varchar(max)

declare @partition...

inm ot a network guy, but maybe you can configure the server so only certain machines/ip ranges can access the ports for the sql server?

i think you can do that,...

i think the easiest way is going to be scripting the tables out, and doing two passes of find and replace to the script.

you can turn off almost all the...

i always hope they'll enhance it a bit so we can use it for more than 4 parts; IP6 stuff is starting to be more common, and other uses as...

i don't have screenshots for 2008R2, but the method is the same;

go to add/remove programs, and rerun the msi by clicking change...once you are in there, an additional step has...

there is a built in function PARSENAME that can help do this, but it only will help if your data has three periods in it.

the function is usually used for...

each drop table statement has to be execute seperately, no wildcards, but you can generate all the necessary statements from the metadata:

then you can copy/paste the commands and run them...

George I've got a TallyCalendar table and the code which updated/added a column to determine if the date in the table was DaylightSavings time or not...is that the same as...

harry.chandra (9/24/2010)

---

Thanks Lowell,

Would this script actually execute the Stored Procedures? Since its a test system with active users, I want to make sure that the SQL wont execute all of...

thre is not an In-Your-Face status like Oracle and other languages have; all you can do is test all the objects and save the results in a table for the...

it exists, but the syntax is a little different:

SELECT *

INTO NEWTABLENAME --creates this table based on the select query

FROM SOMETABLE

i see the proc proc_AutoGEAcctMon

get created, but never called; down towards the end you call a procedure with Execute dbo.proc_cleanNames, but not proc_AutoGEAcctMon

; could that be the issue? forgetting...

does your lookup table have anything to help identify changed rows, like a UpdatedDate or RowVersion or anything ? any chance you could use replication instead?

i think it's just syntax: the query in the parenthesis needs an alias, and you select from THAT:

select month(dateadd(s,creationDate/1000,'1970-01-01')) as mnth, year(dateadd(s,creationdate/1000,'1970-01-01')) as yr

FROM

(

...