Viewing 15 posts - 4,036 through 4,050 (of 7,636 total)
Glad we could help.
January 5, 2009 at 7:54 am
aledochowski (1/5/2009)
kiransuram19 (12/31/2008)
In order to run one job from another both the servers should be linked servers .Then we can run the job from another server.
Actually one can connect to...
January 5, 2009 at 7:47 am
Query #1's problems are probably a case of bad indexing, but are almost certainly solvable in any event. Please provide the execution plan and the table & index definitions.
Query...
January 4, 2009 at 11:00 pm
Glad I could help.
January 4, 2009 at 9:41 pm
we are going to need a better description than this to help you.
January 4, 2009 at 7:57 pm
Nevertheless. Numbers should only be stored as numbers.
The number of people in a town is a whole number only, so it should be stored as an integer.
January 4, 2009 at 7:52 pm
FWIW, I am very happy with how notifications work now.
January 4, 2009 at 7:40 pm
It's a server level object, not a database object. You will find it in SSMS under the server's "Server Objects" folder.
I believe that you can get the...
January 4, 2009 at 7:38 pm
You do not use the Database Master Key at all. SQL Server uses it for you. All you have to do is set it up and forget about...
January 4, 2009 at 6:35 pm
No, the Master Key of each database is unique and unrelated to any other database's master key.
January 4, 2009 at 2:06 pm
All of the doc says that DB Master Key is optional. However, I have never seen an instance where I could get Service Broker to work without it. ...
January 4, 2009 at 12:36 pm
The Service Broker EndPoint just enables Service Broker to send & receive messages to & from other SQL Server Instances and its definition includes the port number that that SQL...
January 4, 2009 at 12:28 pm
Thanks for the data, Wayne. I see that Chris has already posted an updated solution. Please let us know how it works for you.
January 4, 2009 at 11:04 am
Wayne:
We cannot help you any further unless you do two things:
1) Please provide table definitions and sample data in the form of INSERT statments as explained in the link...
January 3, 2009 at 9:18 pm
Jeff Moden (1/3/2009)
Matt Whitfield (1/3/2009)
You are intensely cool. 1.796. And I'll agree with what was said above - i am most impressed by the way you got the data out...
January 3, 2009 at 5:52 pm
Viewing 15 posts - 4,036 through 4,050 (of 7,636 total)