Viewing 15 posts - 18,916 through 18,930 (of 19,564 total)
Yes, there are tools available. With our dts packages we see about a 50% conversion failure rate and have to manually do the conversion anyway.
One such tool that can...
December 5, 2009 at 10:22 am
Alvin Ramard (12/5/2009)
Jeff Moden (12/4/2009)
CirquedeSQLeil (12/4/2009)
You mean I can't run SQL Server on Knoppix and fail replication over to the subscriber on an as-needed basis?:-P:-D
Damn! I was hoping to...
December 5, 2009 at 10:06 am
alternatively, create a script that will concatenate the statement in a set based fashion
select 'grant execute on ['+ name + '] to sa'
from sys.objects
where type = 'fn'
and...
December 4, 2009 at 5:39 pm
Since it is not guaranteed that all of the packages will properly convert, you will need to investigate the packages at the individual level. Are you sure that you...
December 4, 2009 at 5:28 pm
Here is a pretty good read on it.
http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx
In the comments section there is a series of comments by Dave Naples covering User Information Retrieval. In that section he covers...
December 4, 2009 at 5:22 pm
Yes. Sometimes the connection managers may be a bit finicky so you may need to try a few of them.
December 4, 2009 at 5:03 pm
You mean I can't run SQL Server on Knoppix and fail replication over to the subscriber on an as-needed basis?:-P:-D
December 4, 2009 at 4:14 pm
Lynn Pettis (12/4/2009)
When a CTE is used in a statement that is part of a batch, the statement...
December 4, 2009 at 12:26 pm
siddaiah.k (12/4/2009)
yes , I am preparing for interview for ssrs position .plz send ssrs interview questions and answers or send links
Where are you interviewing?
As for the link provided, If you...
December 4, 2009 at 12:21 pm
use the sp_help_revlogin script - execute from the Master database.
You need to execute it from the 2000 server, copy the results to the 2005 server and then execute that.
To verify...
December 4, 2009 at 12:14 pm
For semantics, code in previous post would be:
;
WITH dedupeCTE (ID, DuplicateCount)
AS
(
December 4, 2009 at 12:09 pm
cos_ta393 (12/4/2009)
Jason,Thanks for your assistance. I get an error message as below:
WITH dedupeCTE (ID, COUNT(*) AS DuplicateCount)
AS
(
...
)
...
Change your cte declaration just a little
WITH dedupeCTE (ID, DuplicateCount)
AS
(
December 4, 2009 at 12:07 pm
bitbucket-25253 (12/4/2009)
Hate to be picky but if the ; is at the end of the last T-SQL code line (not a comment line) before the WITH, then doesn't...
December 4, 2009 at 12:05 pm
Bob Hovious 24601 (12/4/2009)
This isn't the right thread for technical questions. I'd move it to one of the usual forums.
No.... that's just what they'll be expecting us to do..... :smooooth:
Glad...
December 4, 2009 at 11:45 am
Viewing 15 posts - 18,916 through 18,930 (of 19,564 total)