| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 global search and replace in SQL database data type ntext Posted by msnews.microsoft.com at 7/21/2006 4:33:04 PM Hello,
I want to do a global search and replace in my SQL database where the data
type could also be "ntext". I did find the code which works for (char,
vachar, nchar, nvachar)
Thank you for your help
regards
...more >>
PLEASE TELL ME Posted by WANNABE at 7/21/2006 10:15:16 AM Is there any need for SQL standard Logins, other then for non-MS systems
like Unix to be able to connect?? Shouldn't all users (who are all using
WINXP systems) be able to do what they need to through Windows Auth?
Please help me out here I just want to be sure, and hear any other ideas,
I...more >>
problem attaching 2000 db to 2005 Posted by Middletree at 7/21/2006 9:00:20 AM I have done this before with no problem, so I don't understand why I can't
do it now.
I have a SQL 2000 database, which I want to copy over to another machine. It
happens to have 2005. I understand that I can't detach and attach a 2005
database to 2000, but I should be able to go from 2000 ...more >>
Stopping SQL Service Posted by skipScout at 7/21/2006 8:12:14 AM Hi folks,
I'm new to SQL Server 2000, obviously, and I need help with the
following task:
I have a server with 2 instances running. I need to stop all access to
one of these instances until further notice.
I have tried stopping the service, but I notice that it keeps
restarting. I test...more >>
Stored procedure help Posted by mita at 7/20/2006 8:57:01 PM Hi guys
I am trying to learn how to use stored procedures..I am quiete familiar with
sql server 2005 but i have never used stored procedures. We have been asked
to run some validation checks on some data provided by our clients.
Could you give me a bit of a direction as to how should i learn S...more >>
Query help needed Posted by msnews.microsoft.com at 7/19/2006 3:34:16 PM Why does this query not work>
I am trying to compare fields in 2 tables and Show me only the results of
fields that are different, I thought this would work, but ... well,
select o.name
from DBNAME.dbo.sysobjects o, DBNAME2.dbo.sysobjects n
where o.name != n.name
...more >>
Copying tables from one DB to anotherq Posted by darrel at 7/19/2006 9:50:33 AM I need to migrate some data from one DB on one DB server to another DB on
another DB server. Can that be done from a SQL query or is this more
involved due to the tables existing on separate physical servers?
-Darrel
...more >>
Loading an MSSQL database Posted by Milagro at 7/19/2006 12:00:00 AM Hi,
I'm new to MS SQL server databases. My experience is in MySql/Perl/Linux.
In MySQL loading data into the database from a file is done by using
the LOAD DATA INFILE command from the mysql command line client.
How do I go about loading data into a MS SQL Server 2005 database via a file?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
What is the best way to diconnect users? Posted by msnews.microsoft.com at 7/18/2006 4:54:49 PM I am about to run an application update on an application that uses SQL
databases, and would like to ensure that there are no users in the database?
I thought from what I've read that it might be best to stop the SQL service,
and restart in single user mode. There are only 2 applications that...more >>
database xfer Posted by Dean at 7/18/2006 1:50:03 PM Hello,
I have a sql database whose tables/content I would like to import into a new
database. Unfortunately, not all the fields match up, some are named
differently and some don't exist in the new database at all. How is this
best done? Is there a tool out there(preferably free) that wil...more >>
View with parameter? Posted by MarcVS at 7/17/2006 3:01:49 PM I'm trying to make a view in SQL Server 2005 with a parameter (WHERE ID =
@param)
I open the view, and put the = @param in the Filter column. I get an error:
'Parameters' cannot be used in this query type
When I click OK, SQL server leaves the statement in the column and puts
'WHERE (dbo.P...more >>
How to convert code Posted by SAC at 7/17/2006 9:12:32 AM I previously posted this in the integration Services but it might be better
here.
I have sql server 2005 and I'm very new to sql server.
Currently, I have some code in MS Access that uses two tables on a sql
server db through an odbc connection.
It loops through the records of a table tha...more >>
Quick Questions Posted by Thanas at 7/17/2006 9:10:10 AM Can SQL Server Express accept remote connections? If so how?
I am trying to copy a database from our main SQL Server 2005 database
to a laptop that is housing a SQL Server Express.
If anyone knows of a better method on how to get a copy to a SQL Server
Express that would be great.
-Thana...more >>
Un-restricted Transaction log file sql 2005 Posted by Moga at 7/17/2006 4:24:38 AM The below script was used to create a database. The transaction log
file was initially created with restricted growth but was changed to
un-restricted growth.
the issue i have is that the transaction log file reverts to restricted
growth when un-restricted growth is specified.
USE [master]
...more >>
Enforcing referential integrity question Posted by CRT## at 7/15/2006 11:40:00 PM How important is it to enforce referential integrity in a database? I'm
working on a SQL database that has no foreign key constraints. The tables
have primary and foreign keys, but the foreign key constraints are implied,
not physically enforced. I did not design this, but I'm wondering, should I...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |