Viewing 15 posts - 91 through 105 (of 335 total)
replace the space with %20, so "just a name" will be "just%20a%20name"
(%20 is hex for 32, which is ASCII for space)
January 20, 2009 at 5:54 am
Interesting:
Microsoft SQL Server 2005 - 9.00.4028.00 (X64) Oct 20 2008 19:33:01 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790:...
January 7, 2009 at 8:55 am
when i checked on the server property at Version i see this
9.00.3042.00
Nope, 3042 isn't SP3, it's SP2. SP3 should give 9.00.4035 (just installed SP3)
See this link http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx for...
January 7, 2009 at 8:35 am
make sure the password for this account is the same on both servers
January 7, 2009 at 3:36 am
Do you have an error message or some detailed logging?
January 7, 2009 at 1:37 am
The problem is quite clear: SQL Server does not exist or access is denied
Seems this script transfers data to another SQL Server?
Check manually if you can make a connection to...
January 7, 2009 at 1:33 am
Just to be sure, the
Build 3790: Service Pack 2
has nothing to do with SQL but with Windows Server.
Have you checked your version with the SERVERPROPERTY function?
January 6, 2009 at 8:13 am
It's also excellent for getting rid of bugs
Brilliant! that's a interesting implementation of RAID. No more bugs on my SAN storage! :):)
December 15, 2008 at 8:34 am
SQL 2000 is dead
SQL 2005 is dying (almost)
SQL 2008 is just born
Go for 2008
December 15, 2008 at 8:22 am
Other question: Why do you have 2 logfiles?
Unlike datafiles, logging is not spreadded over 2 files. It's just filling logfile 1 before using logfile 2
December 10, 2008 at 1:18 am
A lot of application servers are connected to this database and this database is used allday. If I need to stop the database, I have to stop a lot of...
December 8, 2008 at 7:38 am
Thanks for your reply.
Unfortunately, this results in the same error (login failed)
November 27, 2008 at 7:55 am
Other thing I was thinking of:
If you delete a backup, SQL has to do some maintenance in the msdb database. So deleting an outdated backup results in:
- a DOS (yeah,...
November 21, 2008 at 1:42 am
Or you could use a SQL script for the structure and export the data with the BCP utility.
Or save your tabledata by running:
select * into {savedtablename} from {tablename}
November 20, 2008 at 1:27 am
Viewing 15 posts - 91 through 105 (of 335 total)