|
|
|
January 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 December 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 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 [scripts] prompting user Posted by fireball at 12/21/2006 10:26:40 AM please, how to promt user in mu sql 2005 script? For example, I need user to
confirm some operations.. .
Thx in advance
...more >>
Problem with trigger Posted by Jimbo at 12/21/2006 9:26:27 AM Im having problems with an after insert trigger...
Im trying to join the INSERTED table with other tables to retrieve
data....Some of these tables it must link to get data inserted into
them at the same time my original table does...my question is why when
the trigger runs, my sql statement ge...more >>
Writing file from SP with text column Posted by pablo.erba NO[at]SPAM gmail.com at 12/21/2006 3:49:59 AM Hi Everyone, I=B4m new to this group, I=B4m trying to write a text files
adding content from a text column (more than 8000 characters), I found
code how to write files and it works but i have the problem when added
the text column to the body of the file.
any idea? tip?=20
thanks in advance...more >>
The Process Could Not Log Conflict Information Posted by Benzine at 12/20/2006 9:22:15 PM I recently setup merge replication and for each subscriber I add an try
and synchronize I get the following error message:
"The Process Could Not Log Conflict Information"
When I view the details of the error it states the following:
"The Process Could Not Log Conflict Information.
(Sourc...more >>
sp_executesql vs. EXECUTE Posted by fireball at 12/20/2006 6:50:10 PM please, in simple words, what is difference between :
sp_executesql
and
EXECUTE
in sql2005
?
...more >>
if exists condition.. Posted by fireball at 12/20/2006 6:17:24 PM which is more proper:
if DB_ID(@db) IS NOT NULL
or
IF EXISTS (SELECT name FROM sys.databases WHERE name = @db)
?
regards
...more >>
2-3 words in field name Posted by Goran at 12/20/2006 9:42:29 AM Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation" or "Bus_Station"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?
...more >>
Security Tips Posted by coosa at 12/20/2006 5:50:15 AM Dear all,
I'm designing a system including the database and the security
represents the most crucial aspect of the system; hence for the
database security i have implemented the following aspects and need
your advise on further aspects or perhaps corrections where by the
system is web based u...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem with CCommand::Open when query str is too long. Posted by TheOne at 12/20/2006 1:08:26 AM I'm using OLE DB model to insert long texts into ntext field.
My code looks like :
==
BOOL COleDBRowData::Execute(CString strSQL)
{
if(!m_bIsOpen)
return FALSE;
CCommand<CNoAccessor, CNoRowset> rs;
HRESULT hr = rs.Open(m_session, strSQL);
if(FAILED(hr))
return FALSE;
rs...more >>
Max. number od users in SQL server Posted by Goran at 12/19/2006 3:26:07 PM How many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!
...more >>
string function Posted by TGEAR at 12/19/2006 2:48:36 PM select distinct(f.agency+y.year+s.type) as SDNF
In this select clause, I try to use the last 2 digit of year for y.year
value. which function should i apply to it?
...more >>
SQL 2005, "build" scripts? Posted by Eric J. Holtman at 12/19/2006 1:45:16 PM
Am I missing something obvious in the 2005 Visual Studio
portion of SQL Server?
I have a database design, with a bunch of tables, views,
stored procedures, etc, etc. I want to store each object
in a separate file, so I can keep them in Source Safe.
Is there a command that will "rebuild" ...more >>
pagefile and memory advice?? Posted by tlyczko at 12/19/2006 6:48:59 AM Hello, I've been reading about this topic, and I've gotten myself more
confused, not less.
We have a single-processor license SQL Server Standard 2005 (xeon 2.8
ghz) with 4 GB RAM in Windows Server 2003 SP1 Standard.
I turned on the /3GB switch in boot.ini but not PAE or AWE, would it be
go...more >>
Conditional query results Posted by msrviking NO[at]SPAM gmail.com at 12/19/2006 3:33:45 AM Hello everybody,
After several attempts of writing the query, I had to post my
requirement in the forum.
Here is what I have, what I need and what I did.
Table A
Col1 Col2
1 Nm1
2 Nm2
3 Nm3
Table B
Col1 Col2
10 100
20 200
Table C
Col1 (A.Col1) Col2 (B.Col1)
1 10
2 10
Ta...more >>
A question about an error message Posted by Comagmbh NO[at]SPAM gmx.de at 12/19/2006 1:22:57 AM Hello!
I am new to this group and I hope anyone can help me. I have an error
message which is very complicated to me. Okay this message is very
simpel, but I don`t understand how to build my SQL statement. I use
MsSQL 2000 and I am new to Microsoft SQL. I have searched the web and
read the on...more >>
a question about Exec Posted by findu_2005 NO[at]SPAM yahoo.com at 12/18/2006 1:25:09 PM Hi,
When I run the following command on sql server:
exec ('print "OK"')
go
This message appears:
Server: Msg 128, Level 15, State 1, Line 1
The name 'OK' is not permitted in this context. Only constants,
expressions, or variables allowed here. Column names are not permitted.
Why? T...more >>
Replacing NULL value in multiple columns in a table Posted by BF at 12/18/2006 12:50:43 PM Hi,
I have some tables where I import data in, lots of field have gotten a
NULL value which the application can not handle.
Now can I replace each NULL value with '' in a columns with:
update <table> set [<column>] = '' where [<column>] IS NULL
But because there are lots of columns this i...more >>
xp_cmdshell Posted by tolcis at 12/18/2006 9:54:56 AM Hi!
I have a batch file (.bat) that I need to execute inside my stored
procedure (SQL 2000).
I am trying to call that batch file using xp_cmdshell command. I am
probably not using it the right way but I am trying to pass a path of
the batch file into xp_cmdshell and it doesn't recognizes it ...more >>
Split Data file into multiple file groups..! Posted by Query Builder at 12/18/2006 8:45:40 AM
I have one of our production Accounting Databases starting from 2 GB
now grown into a 20 GB Database over the period of a few years...
I have been getting timeouts when transactions are trying to update
different tables in the database.. Most of the error I get are I/O
requests to the data f...more >>
Help!? Combining SQL Queries? Can it be done?? Posted by isdeveloper NO[at]SPAM hotmail.com at 12/18/2006 8:13:59 AM Hi All,
I have a problem with a table that I want to get nice data out of in a
single query. The guys here reckon it can't be done in a single query
but I wanted to prove them wrong !! Essentially, I want to get the same
column out of the single table, but in one case the column must have a
w...more >>
Weird millisecond part of datetime data in SQL Server 2000 Posted by aling at 12/18/2006 4:48:54 AM Execute following T-SQL within Queary Analyzer of SQL Server 2000:
=======================================
DECLARE @dTest DATETIME
SET @dTest='2001-1-1 1:1:1:991'
SELECT @dTest
SET @dTest='2001-1-1 1:1:1:997'
SELECT @dTest
SET @dTest='2001-1-1 1:1:1:999'
SELECT @dTest
=======...more >>
SQL 2000 Stored Procedure move Posted by testbox NO[at]SPAM magaff.co.uk at 12/18/2006 2:53:59 AM I have a MSSQL2000 box with a large database containing circa 150 SP's.
I want to move the DB to another SQL machine, but many of the SP's have
references to the name of the current machine. Is there any way to
batch edit the procedures to refer to the new server, disassociating
the old machine ...more >>
Advantages/Disadvantages to using more than one database Posted by Erik Lautier at 12/17/2006 5:03:13 PM I have a content site where everything is currently in one SQL Server
DB. As I add features to the site, for example message boards and
blogging, does it make sense to put those features in a separate
database? What would I lose and gain in doing so? Thanks so much.
Erik
...more >>
Unable to Display Image Loaded into SQL Server Posted by Erik Lautier at 12/15/2006 4:48:00 PM Hello, I'm using a multipart/form-data upload to put an image into SQL
Server, and it appears to be working, but I'm unable to display the
image. All I'm getting is the text of the URL we're on in Firefox and
a missing image icon in IE! Any ideas why this isn't working? Here's
the image uploa...more >>
View Order Dissappearing Posted by Hurricane at 12/15/2006 12:12:29 PM When I create a view in SQL and include an ORDER BY clause i can see it
in Management Studio. However, when I call the same view from an ASP
page the order goes completely haywire.
Any ideas?
...more >>
How to create the ER Diagram for SQL Server Database objects Posted by sangu_rao NO[at]SPAM yahoo.co.in at 12/15/2006 5:10:53 AM Hi,
I have to prepare an ER diagram for the objects in my SQL Server
database. I have used the option "DIAGRAMS" in EnterPrise Manager of
SQL Server 2000. It is creating the diagram for the selected tables
(but the diagram contains only the table which i have selected. It is
not displaying its ...more >>
Execute proceduers from another Proceduer with error handling Posted by joel.sjoo NO[at]SPAM gmail.com at 12/15/2006 4:03:43 AM I need some help to solve this problem with some stored procedures.
Sens we use ControlM I need to schedule jobs there and not in SQL. With
a simple batchfile I execute an OSQL from ControlM that start a
procedure that calls the other procedures that should bee used. My
problem are the error han...more >>
Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition Posted by Nishant Saini at 12/15/2006 3:01:20 AM Dear All,
We have a database which contains many tables which have millions of
records. When We attach the database with MS SQL Server 2005 Standard
Edition Server and run some queries (having joins, filters etc.) then
they take very long time to execute while when We execute same queries
on ...more >>
max degree parallelism Posted by paul at 12/15/2006 12:00:00 AM hi,
i've set 'max degree of parallelism' to 1 because some sql request hanged.
Now when i connect, how can i set the parallelism to 4 for a session.
Is there a command like this :
'alter session set max degree of parallelism 4' ?
Thanks
Paul
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |