Viewing 15 posts - 4,426 through 4,440 (of 7,505 total)
A proc's return value is to be used more like an execution return code (ok or not ok)
However you can return a row set !
Just run the select statement within...
October 16, 2008 at 12:39 pm
how about the MSDTC settings server side ?
Is MSDTC running ?
Is it configured to accept your time of server-server connection ?
October 16, 2008 at 12:30 pm
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...
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...
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...
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...
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.
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...
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...
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)...
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.
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/
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...
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;
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 ?),...
October 8, 2008 at 12:15 pm
Viewing 15 posts - 4,426 through 4,440 (of 7,505 total)