Viewing 15 posts - 4,426 through 4,440 (of 7,502 total)
I'm sorry. I noticed I pointed you to my service broker article and scripts.
Must have been a twist of mind :crazy:
The mirror testing I was on Two clients with dev-edtn...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 16, 2008 at 11:53 am
I doubt if this is something one should doing "in transaction scope" like within a sproc.
I would convert the sproc into a single sqlagent job, containing of multiple steps.
If you...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 14, 2008 at 10:49 am
Alren (10/13/2008)[hr..Now say user A is a database administrator
G1 the DBA group (sysadmin rights)
G2 a user group able to select some records (in normal situation)
--> this is why I'm afraid...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 14, 2008 at 12:09 am
IMO DENY is the way to go !
It will prevent users of the windows group from accessing your db.
Maybe users are member of more then one group, so they may...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 13, 2008 at 12:28 pm
- Check the installation log files for the reasons why it did no install on the second node !
Only then you can fix it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 13, 2008 at 12:23 pm
-you need to enable tcpip protocol using Sql server configuration manager.
(sql2005 network configuration for you rinstance)
-your client box needs to configure its firewall to be able the connect using...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 11, 2008 at 4:50 am
- are you able to telnet Mirror 5023 ?
- logon to the server using the service account, and then try to telnet the port.
- logon to the server...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 10, 2008 at 12:03 am
it calls a stored procedure at your sqlserver instance.
connect using QueryAnalyser and execute this :
execute sp_help procSalesReportsMMCommBySector
I expect it to have a number of input parameters (at least 10)...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 9, 2008 at 8:10 am
I would advise Backup prod and Restore on dev if the size permits it.
Straight forward and controllable.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 9, 2008 at 7:46 am
can you use this to solve the problem ?
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
and / or
did you read my adventures with SSB ?
http://www.sqlservercentral.com/articles/Service+Broker/2897/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 9, 2008 at 7:41 am
IMO you should use "where exists (*** correlated subquery)"
EXCEPT works on the full rows columns, so it needs two result sets to compare row by row, column by column.
As...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 1:08 pm
You have added all files to FG1 !!!
FG2 does not exist !
--alter database AssignDB
--add file
--(
--Name=FG3_dat,
--FileName='C:\ClassAssign\FG3.ndf',
--Size=30MB,
--MaxSize=50MB,
--Filegrowth=5MB
--)
--to filegroup FG1;
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 1:01 pm
Use:
- professional help ( SQLserver and shrink 😉 )
Both should be good
Some more info needed:
- OLTP / OLAP ?
- 15TB plus .... how many processors (cores ?),...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 12:15 pm
You cannot alter a UDT if it is used by objects.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 12:08 pm
do you mean
update yourtable
set yourcolumn = ''
where yourcolumn = 'NULL' -- column actually contains value NULL
or
update yourtable
set yourcolumn = ''
where yourcolumn is NULL -- column actually...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2008 at 12:01 pm
Viewing 15 posts - 4,426 through 4,440 (of 7,502 total)