Viewing 15 posts - 4,426 through 4,440 (of 7,496 total)
- 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
You cannot alter a UDT if it is used by objects.
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...
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...
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...
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...
October 8, 2008 at 5:11 am
You have to open the needed port(s) clientside in the firewall.
HowTo ? That depends on the firewall software that is installed.
more info: http://support.microsoft.com/kb/287932
October 8, 2008 at 2:24 am
Since this is a clean install, I would upgrade to SP2 + CU9 or 10
and only then try debugging this
October 7, 2008 at 1:59 pm
Did you enable sqlserver for his firewall (client side) ?
October 6, 2008 at 7:02 am
Viewing 15 posts - 4,426 through 4,440 (of 7,496 total)