Viewing 15 posts - 7,816 through 7,830 (of 13,469 total)
souldn't the data be ('04/04/2011...
or the pattern be M/D/YYYY...
April 6, 2011 at 12:04 pm
like this: just tested it:
select * from
(
select definition,myf.* from sys.sql_modules
cross apply dbo.DelimitedSplit8K(definition,' ') myf
where definition like '%[A-Z]@_%'
) myAlias
where Item like '%[A-Z]@_%'
April 6, 2011 at 11:44 am
well as a start, you could limit it to only procs/functions/triggers that have strings that might be an email;
this certainly found the two objects i have that have a hardcoded...
April 6, 2011 at 11:39 am
for addresses, there are a number of services that will standardize your address info for a fee;
if your cheap or just like a challenge (like me) what I've done is...
April 6, 2011 at 11:12 am
the SQL statement is wrong.
if you are going to use double dots, which tells the linked server to get the default object, it is like this:
it has to be Select...
April 6, 2011 at 9:38 am
think about it: how many unique employees receive two salaries? i doubt any in this table.
maybe you need to join to a different table, say the payroll table, so you...
April 6, 2011 at 7:04 am
subrat_4ualways (4/6/2011)
HiThe query is
Select * from emp_details order by EmpId desc,EmpSal
The output I am getting is Empid desc only....
Many Thanks
Subrat.
I think David nailed it, unless an EmpId appears more...
April 6, 2011 at 6:37 am
Sounds pretty wierd; can you script the linked server command out so we can see it? that woudl be most helpful in the diagnosis; you are of course sure you...
April 6, 2011 at 6:25 am
When SQL server runs out of disk space, it stops and tells you it ran out of disk space...it doesn't automatically disable CDC, trace, jobs or any other service from...
April 6, 2011 at 6:05 am
can you change things like the connection string of the web application?
if you could get the web application to change the Application Name attribute on a per-page basis, you'd have...
April 5, 2011 at 3:12 pm
you had previously said you had this setting "Be made using login's current security context" set."
The typical issues for linked servers tend to be related to which security context you...
April 5, 2011 at 2:04 pm
Steve how good are you with programming?
I use this function as part of a larger ETL program i wrote; once I have a datatable, i can pass it to this...
April 5, 2011 at 12:31 pm
if not too much time has passed, the default trace keeps track of DDL(CREATE/ALTER/DROP object changes)
the easiest way is with a report that exists in SSMS:

April 5, 2011 at 12:19 pm
any chance of changing the schema? at least adding a column to be removed after the data transfer?
whenever I've done a data migration like this, I've always added a column...
April 5, 2011 at 10:06 am
what you want to do is wrap this up into a stored procedure, and use parameters;
here's an example of the code, and then how to call it: note the procedure...
April 5, 2011 at 9:18 am
Viewing 15 posts - 7,816 through 7,830 (of 13,469 total)