| Groups | Blog | Home |
|
January 2003 March 2003 April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 July 2007 August 2007 September 2007 October 2007 |
shrinking transcaction log Posted by Tony Talmage at 5/27/2004 2:05:48 PM I was wondering, what's the most efficient way to shrink the size of the
transaction log? Our log is currently taking up 4.5 GB more space than it
should, and we would like to shrink it to a more reasonable size, but all
the information I've found by reading through articles found through Google...more >>
declare inside exec Posted by Kasper Birch Olsen at 5/20/2004 2:08:58 PM hi guys
I need to do exec('declare @myvarnumber'+@numvar+' varchar (100)')
But eventhough sqlserver says "The command(s) completed successfully.", the
var doenst exist afterwards.
Can this problem be fixed?
- Kasper
...more >>
sql applications won't open Posted by b_outwater NO[at]SPAM yahoo.com at 5/19/2004 6:34:40 AM I can not get any of my sql applications to open. Enterprise Manager,
Query Analyzer, sqlmaint.exe, etc. I've tried installing the latest
service packs. These haven't been working ever since I first
installed sql. Would completely un-installing this and reinstalling
fix the problem. Any hel...more >>
[can I] create a table with foreign key that doesn't exist? Posted by dp at 5/17/2004 2:36:20 PM Is it possible to create a table, and specify a foreign key to a table that
I haven't created yet?
Is it possible to do this, or must I create all the tables, and then go back
and alter them with the appropriate foreign keys.
Thanks in advance!
-Brian
...more >>
TextCopy problem with file size in multiples of the chunk size Posted by contact NO[at]SPAM itdesign-inc.com at 5/17/2004 9:07:43 AM Hi all,
I just encountered a problem with textcopy.exe in SQL Server 2000,
SP3. When uploading an image file, JPG, into an image column, the
textcopy.exe randomly fails if the file size is an exact multiple of
the chunk size.
Example: Loading an image of 110,592 bytes (27x4096), randomly fails
...more >>
why do I notice locks when I don't use lock hints? Posted by avisemah NO[at]SPAM optonline.net at 5/16/2004 12:31:36 PM hi,
I have a vb application that runs on a remote machine with respect to
the machine where SQL 2000 is. At times it accesses the sql database
using ActiveX ADO 2.8. When the application run I notice tht wehn i
go to Management--> Current Activity--> Locks/Process ID under the sql
relevant ...more >>
SQL 2000 substantial performance degradation problem????? Posted by avisemah NO[at]SPAM optonline.net at 5/16/2004 11:40:17 AM what could be the reason that ms sql 2000 performance is 10 times
slower when used in remote connection compared to LAN connection,
while remining in both case with same ISP and same speed of kilobits
per second (intennet nabdwidt)?
any assistance will be much appreciated...more >>
How to redirect a DTS package and connections Posted by SD at 5/11/2004 2:52:39 PM Hi,
I have a DTS package (SQL2k, sp3) that I can to execute agains a new
database in the same server. I don't see how to easily redirect. If you
change the connection properties and clear the transformations you have to
redo them one at a time (too long).
If you don't data still goes to the...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
TEXT to VARCHAR losing CRLF Posted by Jethro at 5/10/2004 10:21:58 AM Hi all
I am doing a SELECT on a table which has a TEXT field, which has values with
CRLF embedded. like so
SELECT myfield FROM My table
Line1
Line2
Line3
I want to be able to concatenate a CONVERT(varchar,integer_value) to this to
get :
2
Line1
Line2
Line3
However the "+" op...more >>
What did I do wrong? Posted by graham at 5/9/2004 6:43:34 PM Hi All,
Wonder if anyone can shed some light on a problem that arose on Friday, that
I am still in shell-shock from..
SQL2000 on W2Kserver.
On Thursday evening, I performed what I thought was a much-needed
modification on our database - specifically, I have a 7.5million record
'prospect'...more >>
Can not install Reporting Services, Help! Posted by SD at 5/3/2004 7:01:23 PM Hi,
I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm trying
to install the MS SQL Server Reporting Services that is in the MSDN of April
2004. I also have Visual studio.net installed.
So when I run the CD all goes well until you specify the database for the
reporting se...more >>
How to publish dashboard for SQL Server Posted by simonlenn NO[at]SPAM yahoo.com at 5/3/2004 6:35:31 AM I have a requirement to publish dashboards for SQL Server like gauges,
sliders, graphs, etc to a digital dashboard.
Please advise which is the best way to publish dashboards on SQL
Server. Also please point me to some resources on some sample
dashboards to SQL Server.
If it is Sharepoint ca...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |