| Groups | Blog | Home |
|
March 2003 May 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 November 2007 |
Executing an sql script on a remote database from Visual Studio .NET 2005 Posted by Nathan Sokalski at 9/28/2006 5:09:41 PM I am connecting to a remote SQL Server database from Visual Studio .NET
2005. I have an sql script located on my machine containing the sql code I
want to use to create several tables, and want to execute it. How can I do
this from Visual Studio .NET 2005? I do not like designing the database ...more >>
reg DTS Package Posted by samay at 9/27/2006 7:12:22 PM hi can any one help me in this issue.i use to get one text file as an
attachment from one email id weekly.the file name and email id is
same.so i want that file to be automaticaly imported to a table and
updated as per the schedule i have assigned.so wen i get that mail that
pervious table shoul...more >>
DateDiff Posted by Rogers at 9/27/2006 6:37:48 PM I am using DateDiff format like DATEDIFF(hour,Start,End) and it gave me the
result 12 hours.
Start:- 22 Sep 2006 09:30:00
End:- 22 Sep 2006 21:00:00
Is there any way it will return me 11.5 instead of 12 because it start from
9:30 and end at 21:00 so it must be 11.5 not 12 hours right.....more >>
auto format of stored procedures?? Posted by Freddy at 9/25/2006 3:43:35 PM hi,
i have many stored procedures, and i'm currently working on one with many
levels of nested IF's. it came from someone else, and i'm modifying it.
So...i'd love a utility, that i've seen in most other dev environments, that
will 'pretty print', or automatically format all the levels of...more >>
SQL 2000 Desktop Edition Posted by Rogers at 9/20/2006 9:41:41 AM Can anyone give me the URL to download SQL Server 2000 Deskop edition which
is free and the client tool which is also free (Enterprise manager and query
analyzer)
Thanks
...more >>
Cannot find member name System.Data.SqlClient.SqlError Posted by Kim Floyd at 9/20/2006 9:23:03 AM I have a client server app that is using remoting. The server is running
2003 the client is running XP. If I get and SQL error on the server I do not
receive the correct error message on the client. The error I get on the
client is “SerializationException: Cannot find member name
System...more >>
MCP Exam sql 2005 Posted by Sathiamoorthy at 9/19/2006 12:00:00 AM I want to prepare MCP exam for sql server2005.
Any one give the guidance and study materials for me.
Regards,
R.Sathiamoorthy
...more >>
Replacing a column in a select Posted by ThunderMusic at 9/14/2006 8:32:18 AM Hi,
Here's my problem : I have to do a Select on a table containing about 150
columns... The thing is I have to "redifine" 1 column. This column must have
the same name because it is used in all the application, but now I have to
tell the select that if this field is null, replace it with a s...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Security Q: Posted by Ana_T at 9/12/2006 12:00:00 AM Hi,
I use Access and .asp pages to connect to my SQL 2k Server. Both
applications use user and password to connect.
This morning I wanted to create some graphics using Excel drawing data from
a query.
To my surprise, I was able to connect to the SQL server without a problem
and creati...more >>
Cant see server by servername Posted by spitapps at 9/9/2006 7:03:59 PM When i am connecting locally to my server I cant seem to connect to the
server using the server name just by IP address. Does anyone know what
is happening and how to fix it??
...more >>
Modify a record Posted by yba02 at 9/9/2006 10:13:01 AM Hi,
In SQL 2000 server, I am unable to manually modify a record in a table from
the Enterprise Manager installed on the same server as the database itself.
When trying, I get a message that says something like "the record you are
trying to modify has been altered by anotheruser...". However,...more >>
SQLExpress and Windows XP Firewall Posted by News.Microsoft.com at 9/9/2006 1:06:27 AM I cannot connect remotely to a machine that is running SQLExpress while the
XP firewall is on. I have opened up ports 1433 and 1434, but it doesn't
help. If I turn the firewall off, then I can connect. Any suggestions?
Bill
...more >>
image data type Posted by Rogers at 9/8/2006 10:32:11 AM I am using visual studio 2005 and trying to upload image / binary data from
the application side and trying to save into SQL Server 2000 - image column,
I am wondering which datatype I have to used in application side as image
datatype is not available in Visual Studio 2005.
Can any one let...more >>
Alter table problems (transaction log will growth to 60 Gb...) Posted by Major at 9/8/2006 9:40:11 AM I have a large table, and I try alter one column:
ALTER TABLE TABLE_NAME ALTER COLUMN COLUMN_NAME DECIMAL (15,9)
The transaction log will growth to 60 Gb, and then I haven't any more disk
space avalable.
Does the SQL server have any parameter like NOLOGGING
or does somebody have other so...more >>
Customer wants nightly backup of 100 gb database Posted by rfreiberg NO[at]SPAM geosolinc.com at 9/8/2006 8:18:57 AM We have a customer that is requesting that we send them a nightly
backup of a database that is 100gb. We currently do this for our other
customers by creating a backup and putting it on a ftp server. A 100gb
database is going to take an awful long time to backup and zip.
Is there another way t...more >>
Crystal Report To PDF and SQL Email. Posted by Rogers at 9/5/2006 6:10:16 PM I have two crystal reports that contrains complex graphs, I want to create
script in SQL Server to export that crystal report into PDF format and send
couple of customer. Is that possible ?
Regards
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |