Viewing 15 posts - 3,046 through 3,060 (of 3,738 total)
davidshephard (5/17/2011)
I guest my question is can you coonect to SQL server from multiple machines using the same credentials.
If you are using WIndows Authenication then you have no option but...
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 17, 2011 at 11:21 am
sqlsponge2 (5/17/2011)
I am trying to build a deployment package for a couple of databases to automate the process. I have three databases that I would like to restore 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 17, 2011 at 11:18 am
davidshephard (5/17/2011)
Strange thing I tried from a Windows machine via ODBC tools and it also failed but it still works from the initial machine
I'm not surprised, you probably don't have...
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 17, 2011 at 11:10 am
bijarcity (5/17/2011)
my project is that,and i have to implement that ,so do you have any idea about that ?
Your project is not a cake walk.
You want to start out by...
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 17, 2011 at 11:08 am
davidshephard (5/17/2011)
Its one SQL server, from client 1 we can connect no issues,from client 2 two using the same credentials it throws a error message.
Then you do not have a...
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 17, 2011 at 10:58 am
davidshephard (5/17/2011)
The server is using Windows Auth,he is connecting from two diffrant Linux clients.
"BAD PASSWORD" is not an error that I would expect. Do you have additional details in 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 17, 2011 at 10:33 am
Duran (5/17/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 17, 2011 at 10:28 am
davidshephard (5/17/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 17, 2011 at 10:17 am
Duran (5/17/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 17, 2011 at 10:02 am
I know how to navigate to the properties window. 🙂
Are you asking how to dynamically set the properties in code?
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 17, 2011 at 9:40 am
dlmagers (5/16/2011)
Msg 8152, Level 16, State 14, Line 1String or binary data would be truncated.
bitbucket-25253 (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 4:03 pm
martynjreid (5/16/2011)
Welsh Corgi (5/16/2011)
Thanks, unfortunately this is a released product with about 20 clients. We support SQL2005 and cannot realistically change. I need to support our existing clients.
If you only...
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:46 pm
What time constraints are you looking at?
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:41 pm
bijarcity (5/16/2011)
not dividing ,(server C) just check the Servers A,B ,to know which one is connected
I should have been more clear.
Why do you need to create a distributed database environment?
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:37 pm
If you could upgrade to SQL Server 2008 and use the Change Data Capture Method you would be better off.
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:34 pm
Viewing 15 posts - 3,046 through 3,060 (of 3,738 total)