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)
Wilfred
The best things in life are the simple things
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:...
Wilfred
The best things in life are the simple things
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...
Wilfred
The best things in life are the simple things
January 7, 2009 at 8:35 am
make sure the password for this account is the same on both servers
Wilfred
The best things in life are the simple things
January 7, 2009 at 3:36 am
Do you have an error message or some detailed logging?
Wilfred
The best things in life are the simple things
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...
Wilfred
The best things in life are the simple things
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?
Wilfred
The best things in life are the simple things
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! :):)
Wilfred
The best things in life are the simple things
December 15, 2008 at 8:34 am
SQL 2000 is dead
SQL 2005 is dying (almost)
SQL 2008 is just born
Go for 2008
Wilfred
The best things in life are the simple things
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
Wilfred
The best things in life are the simple things
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...
Wilfred
The best things in life are the simple things
December 8, 2008 at 7:38 am
Thanks for your reply.
Unfortunately, this results in the same error (login failed)
Wilfred
The best things in life are the simple things
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,...
Wilfred
The best things in life are the simple things
November 21, 2008 at 1:42 am
Try defrag your disks
Wilfred
The best things in life are the simple things
November 21, 2008 at 12:35 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}
Wilfred
The best things in life are the simple things
November 20, 2008 at 1:27 am
Viewing 15 posts - 91 through 105 (of 335 total)