Viewing 15 posts - 6,796 through 6,810 (of 8,760 total)
Quick questions, which product code? Is there only one product code or should it be any product code? What's the role of the variable, wouldn't it be better to have...
October 14, 2014 at 12:02 am
kyiaun (10/13/2014)
Declare @id int
Declare @i int
Declare...
October 13, 2014 at 11:28 pm
skb 44459 (10/13/2014)
I have already done TCP/IP changes. But still does not work.
Then everything is pointing to the name resolution, check the DNS, win host name etc.
😎
October 13, 2014 at 11:17 pm
Quick solution and an opposite problem to Jeff's, lots of coffee but yet to be drunken.
😎
USE tempdb;
GO
IF (SELECT OBJECT_ID(N'dbo.example')) IS NOT NULL DROP TABLE dbo.example;
create table dbo.example
( a int null,
b...
October 13, 2014 at 10:24 pm
skb 44459 (10/13/2014)
looks like after renaming the server. it didn't chage it.
You cannot rename an instance, only the server
😎
October 13, 2014 at 10:14 am
Quick suggestion, in SQL Server configuration Manager, Server Network Configuration, Protocols for SRVDR, Enable TCP/IP. Then in the properties window set TCP Dynamic Ports 0 or blank and all IP...
October 13, 2014 at 10:09 am
One more question, in cmd what does reg query "HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL" return?
😎
October 13, 2014 at 9:34 am
skb 44459 (10/12/2014)
i was able to connect using sql studio using 'SRVDR' as Server Name.
Also other application was able to use server name 'SRVDR'
We changed...
October 12, 2014 at 10:34 pm
Haven't experienced the 0 duration, must improve the harness, using this quite a lot, all suggestions welcome;-)
😎
October 12, 2014 at 2:00 pm
This is on a mediocre i5 laptop (E6220), single SSD (3rd gen) and SQL Server 2014, similar results on both 2012 and 2008 R2 on the same system. Tempdb has...
October 12, 2014 at 1:18 pm
rym2001 (10/12/2014)
October 12, 2014 at 12:45 pm
rym2001 (10/12/2014)
October 12, 2014 at 11:54 am
Jason Shadonix (10/12/2014)
Eirikur Eiriksson (10/12/2014)
Quick thought, check the file system permissions for the account on the folder specified (<path>)😎
I finally figured this out. I'm not exactly sure why my...
October 12, 2014 at 10:38 am
dcarter 43846 (10/12/2014)
I did try to delete this topic as it was a duplicate but couldn't find the button!
No worries;-)
😎
October 12, 2014 at 6:59 am
Duplicate topic, answer here
😎
October 12, 2014 at 6:49 am
Viewing 15 posts - 6,796 through 6,810 (of 8,760 total)