|
|
|
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 Two instances - authentication question Posted by mcron at 7/28/2006 1:48:02 PM I have an existing installation of SQL Server 2000 configured for Windows
authentication. I have a new application that requires SQL Server and
Windows authentication. If I install SQL Server 2000 on this server again,
am I creating another "instance"? Is the authentication method specific ...more >>
Howto remove decimals in a numeric field Posted by Ana_T at 7/28/2006 12:00:00 AM Hi,
I use a numeric field (vs. nvarchar) to log the KM of a vehicle because I'd
like the data to be displayed with the 1000 separator (123.456). In a web
page, the data is displayed with decimals (123.456,00). I removed the
decimal setting in the server's regional configuration with no avai...more >>
how to move a bak file to another machine? Posted by CRT## at 7/27/2006 9:51:29 PM I want to move a copy of a database (bak file) to my local machine so I can
have access to the data offline.
My goal can be thought of as copying a database, data and structures, to my
local machine.
How do I do that? Do I restore it? When I try to restore it using Enterprise
Manager, I see...more >>
How do I print off a Relationship View of my tables????? Posted by rhaazy at 7/27/2006 11:13:34 AM Can I print off something that has all my tables and their column names
along with all the relationships between them???/
...more >>
sending emails with sql server Posted by Sam at 7/27/2006 12:00:00 AM how can i automate sending emails from sql server?
can it be sent with attachments?
thanks
...more >>
Database Size Posted by Microsoft at 7/26/2006 4:20:21 PM I have a 20GB database and i recently delete a 2GB table from it, but still
it shows as 20GB database. I have done a backup on both transaction log and
..data file but it didn't help.
any idea how can i free up that 2GB space?
Thanks
Hooman
...more >>
Finding Database Object Permissions Under A Role Posted by G. Ray Giacalone at 7/26/2006 11:22:13 AM Is there any way of finding all of the database objects and their permission
settings that are assigned to
a role in SQL 2005?
This was available in SQL 2000's interface :-(]
THANK YOU VERY MUCH!!! :-[)
...more >>
Startup of SQL Server and Sql Agent Service Account|Suspect Database Posted by Bill Papanestor at 7/26/2006 9:00:17 AM I am trying to setup a domain user to that will be used to start-up the SQL
server and agent services.
I am on a 2003 domain using SQL 2000 SP 4
The domain user is not part of the local administrators group where the SQL
Server is loacted but I have assigned the local policy privileges as
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Getting rid of leading 0s in strings Posted by Orlando Acevedo at 7/25/2006 12:07:46 PM I am trying to use several tables that have one 10-character text field in
common.
Most of the records have a numeric expression, but some tables have leading
0's, and some don't.
I can't cast the field to numbers because there are some records that have
letters also.
What function can I us...more >>
Device not ready--what does that mean? Posted by Middletree at 7/25/2006 9:27:31 AM Been struggling with this for way too many hours. I am trying to get a
database copied from one location to another. The place it's coming from is
SQL Server 2000. The destination is SQL 2005. They are not on the same
network and I cannot connect them to do an import.
First, I tried detachi...more >>
easy one here >> Query help, please Posted by WANNABE at 7/24/2006 11:15:32 AM Need to change part of a field, and I 've been running some tests in pubs.
This gives me and error>
update authors
set substring(phone,5,3) = '888'
where substring(phone,5,3) = '826'
this is the error >
update authors
set (substring(phone,5,3)) = '888'
-----------------------------...more >>
Import/Export issue Posted by mita at 7/23/2006 8:16:01 PM Hi guys
I am trying to import a text file into sql server but sql doesnt let me do
that.
My flat file is in the txt format.
Here is a part of my txt file
Indicatorid,IndicatorName,Reportingquarter,SourceDate,DHB,DHBName,PHO,PHOName,Practice,PracticeName,Practitioner,PractitionerName,NHI,DOB,...more >>
How to use local format file to bcp local data to remote server Posted by JohnsunKan at 7/23/2006 12:00:00 AM
How to use local format file to bcp local data to remote server?
If I use a local fmt file then system reponse "could not find the driver".
If I use DTS to bcp to a remote server, I only can find the remote server's
driver...
Is it possible to use bcp (local data & fmt file) like that ...more >>
SQL DB Error Newbie Posted by Thomas Grassi at 7/22/2006 9:58:34 AM I got this error the other day any ideas?
Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 6004
Date: 7/19/2006
Time: 8:47:58 AM
User: N/A
Computer: TGKW001
Description:
Sqllib error: Database WrestlingHistory is not simple.
For more information, see Help and Supp...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |