Viewing 15 posts - 3,061 through 3,075 (of 3,738 total)
You may want to check the data types involved.
I suggest that you narrow down the columns transfered to a few columns to isolate the problem.
MCDBA, MCITP, MCSE, OCP
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 3:28 pm
I sounds like you are filtering on the wrong column within the trace? NTUserName vs LoginName...
Is NTUserName populated?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 3:14 pm
bijarcity (5/15/2011)
Thanks for your website.
I have a question about distributed system.
we have a project about distributed systems but the problems that we have is about how we can design this...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 3:05 pm
rajeevmehr (5/16/2011)
In the 'test', duplicates are deleted where in 'prod' instance it was not. when i...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 2:53 pm
dlmagers (5/16/2011)
That is alright I corrected the problem. Thank you.:-)
How did you correct the problem?
My guess is that you did what Ron suggested.
Please post the problem and the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 2:46 pm
rajeevmehr (5/16/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 2:35 pm
Is the article listed below any use to you?
http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/086159da-9580-4ed1-aaba-8fdd4c861f17
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 2:03 pm
Coolganny (5/11/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 1:28 pm
Are you getting any errors?
Have you checked permissions? 😉
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 1:07 pm
Tara-1044200 (5/16/2011)
SELECT top 10 empid,empno,jdate FROM OBBEAVER.Rev_Staff.dbo.employee
I get this error
Msg 7313, Level 16, State 1, Line 2
An invalid schema or catalog was specified for the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 1:01 pm
martynjreid (5/16/2011)
I have developed a process which takes a non-SQL database, extracts data, loads it into a SQL database in a temp storage area before it generates a reporting...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 12:51 pm
Kenneth Fisher-475792 (5/16/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 11:49 am
Is this any help?
http://msdn.microsoft.com/en-us/library/ms189797.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 11:24 am
Please refer to the following article by Jeff Moden:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 11:19 am
I found this article interesting:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 11:15 am
Viewing 15 posts - 3,061 through 3,075 (of 3,738 total)