Viewing 15 posts - 6,871 through 6,885 (of 9,244 total)
Joy Smith San (7/19/2011)
Thanks Perry.Will this work for SQL 2000 as well.? If not whats the equivalent.?
Thanks again.
No, the following will work for SQL Server 2000.
select ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2011 at 4:04 am
Which browser are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 11:45 pm
Jeez, we're not still flogging this dead horse are we 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 3:35 pm
Could you provide more info on the iSCSI setup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 10:35 am
don't disable the services, set them to manual startup and then use 'NET START' command to start the services. Incidentally, why is it taking so long for the storage to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 10:08 am
pshaship (7/18/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 10:04 am
Marios Philippopoulos (7/5/2011)
Also suppose that role dbRole2 is also a member of dbRole1.
Implicitly, login1 is now mapped to both roles,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 9:35 am
are you aiming at just user created database roles or fixed roles too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 9:22 am
keyun (7/18/2011)
What is the best method of updating your production server dbs from your development?
Currently, we are running daily process at night to backup our database and restore on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 8:42 am
Joy Smith San (7/18/2011)
Hi,How can list all the users of a particular database.
I want to list only those users coming under the "Users" in "Security".
Thanks.
This should get you started, it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 8:38 am
editing the registry ad hoc is never supported. Some support or Knowledge base articles will provide details for modifying the registry and will always advise a backup first.The keys to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 6:34 am
Jayanth_Kurup (7/18/2011)
If SQL is already compressing the backup
This feature is not available in SQL Server 2005
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 5:48 am
what version of SQL Server 2008 are you installing?
Have you thought of slipstreaming any updates or using a drop merged media?
I do seem to remember this being an issue with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 5:37 am
Jeff Moden (7/17/2011)
It'll take me a couple of hours but...one lesson in "set based" thinking coming right up.
looking forward to that already Jeff
Jeff Moden (7/17/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 5:28 am
guthey.aditya (7/18/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 4:21 am
Viewing 15 posts - 6,871 through 6,885 (of 9,244 total)