Viewing 15 posts - 1,141 through 1,155 (of 1,155 total)
If the text only has one period you could use the following:
DECLARE @Col VARCHAR(35)
SET @Col = 'ABCDEFGHIJKLMNOPQRST.0987654321'
right(@Col,len(@Col) - charindex('.',@Col))
October 15, 2007 at 9:53 am
glad to hear it. Good luck with everything.
October 12, 2007 at 10:54 am
If you chose mix mode authentication, you should have been prompted to create a password.
login using sa and the password.
If you chose windows authentication, the sa is disabled by default.
October 12, 2007 at 10:08 am
andrewbrinker stated that he used surface area config. to allow remote connections via tcp. Shouldn't surface area conf update this setting when it implements the change to allows remote connections?
October 12, 2007 at 9:47 am
small squares like this ? represent carriage returns
October 12, 2007 at 9:40 am
you created an SA account when you setup the instance. Login using sa and setup a sql login for yourself.
October 12, 2007 at 9:07 am
sp2 cannot be removed via add/remove programs, when the SQL Instance in unistalled sp2 is removed.
There is more documentation/instruction on uninstalling sp2 here
October 12, 2007 at 8:32 am
When you create a named instance you should connect as as servername\instancename, so you should try servername\WINSERV1
Additionally, have you tried to connect to the server with the specified port?
October 12, 2007 at 8:21 am
Alanz and Grant, I would agree with your solution, the query plans speak for themselves. The proposed solution is much more efficient and logically cleaner.
October 12, 2007 at 6:56 am
I previously posted a solution; however, I had a mistake in it. I had forgotten to put a where clause in the subqueries, thus the result set would throw...
October 11, 2007 at 5:13 pm
according to this article, upon shutdown and restart of SQL Server another port is selected
October 11, 2007 at 3:52 pm
Yes, I would say that the database engine has not been installed.
October 11, 2007 at 3:34 pm
This should do the trick.
SET Col3 = (select ColC from TableB t2 inner join TableA t1 on t1.Col1 = t2.ColA where ColA = TableA.Col1),
Col4 = (select ColD from TableB...
October 11, 2007 at 3:27 pm
SQL 2005 Developer edition uses sqlwb.exe. SQL Server express edition uses ssmsee.exe to execute. If SQL 2005 has been installed correctly you should be able to Start -->...
October 4, 2007 at 12:40 pm
Yes, restore from a production database backup to bring the test database to a consistent state with the production database.
It is always beneficial to start a new project from a...
October 4, 2007 at 12:22 pm