Viewing 15 posts - 31 through 45 (of 172 total)
Yeah, I logged on to the server and ran the exact command that was created in the script because I was afraid maybe some kind of OS change might have...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
July 20, 2009 at 9:24 am
No, I know how to script the jobs using Management Studio. I am trying to figure out a way to setup a nightly job that creates scripts of all...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
June 23, 2009 at 11:58 am
Thanks but those are just reports of the jobs on the server and they don't work in 2008 anyway.
I'm trying to come up with a way to script out all...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
June 23, 2009 at 11:14 am
Thanks, I'll look into that. I also had another idea of executing on procedure and using the EXECUTE AS function to change the context.
Either of these should work.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
February 11, 2009 at 9:29 am
Yes, the max server memory is set at 7168. This has been confirmed both graphically and using sp_configure.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
February 3, 2009 at 7:57 am
Yes, I agree, that is the way the query should be done but it is out of my hands at this point. They want the redundant data.
We're actually going...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 29, 2008 at 1:18 pm
I did what you said and everything worked like a charm!
I was able to add the server as a Linked Server and now I can query directly against the server.
At...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 1, 2007 at 3:22 pm
Thank you. I'll do what you said. It's development, so even if I mess something up, we can always get back to where we were.
My knowledge of replication...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 1, 2007 at 3:14 pm
Actually, "no value" does not mean 0.00 and NULL definitely does not mean 0.00. NULL means unknown or no value.
I have worked with, and continue to work with, several databases with tables...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
February 26, 2007 at 7:12 am
Thanks for the link. That cleared it up.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
November 22, 2006 at 7:32 am
Sorry, this is a little off the main topic here but, I have been away for a while so I'm behind. What sale are you referring to?
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
November 22, 2006 at 7:10 am
My initial data is in a staging table and I am having to write the data to a new table.
I have to truncate the new table every time and reload...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 24, 2006 at 11:25 am
Oops, my bad. I was trying to setup a sample of what I am doing because the actual tables and data has many fields and combinations. I was trying to...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 24, 2006 at 11:20 am
Thanks for the response. I too am a programmer at heart so the procedural approach is the easiest but, and I forgot to mention this, the problem there is that...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 24, 2006 at 11:13 am
If you want to get the accounts that are in those groups, you can use the xp_logininfo command. Use it in the following manner:
EXEC master..xp_logininfo 'DOMAIN\Group', @option = 'members'
Good luck!
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
June 12, 2006 at 12:14 pm
Viewing 15 posts - 31 through 45 (of 172 total)