Viewing 15 posts - 4,426 through 4,440 (of 7,499 total)
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
Yet another query 🙁
Maybe you'd be better off just copy/paste-ing the actual thing you want...
What is this selects giving you as a result:
Select count(*)
from myTable
where [CAR1] IS NOT...
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 10:52 am
metalray (10/8/2008)
Issue solved,I just changed the order of columsn in my INSERT statement from
INSERT INTO dbo.myTable(Code,Amount, Car)
to
INSERT INTO dbo.myTable(Code,Car, Amount)
Hey, hey, ..... that's not what you posted first...
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 8:04 am
metalray (10/8/2008)
I am down to one column that causes a problem. I have a simple INSERT:
INSERT INTO dbo.myTable(Code,Car, Amount)
SELECT
[AR] As [Code], --Year
[SDF] As Car , --Vendor
[SVB] As Amount...
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 5:11 am
Viewing 15 posts - 4,426 through 4,440 (of 7,499 total)