| 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 mixed quotes in table description using sp_addextendedproperty Posted by Rob Schuff at 5/21/2006 8:18:21 AM Folks,
I'm having a Little trouble figuring out how to add a table description
using sp_addextendedproperty where the description has mixed single and
double quotes such as:
This table's description is "weird"
Anyone have an idea?
thanks....more >>
Syncing with access Posted by John at 5/21/2006 3:26:54 AM Hi
Is it possible to reliably sync an access db with its equivalent sql server
db using the built-in facilities of sql server and access?
Thanks
Regards
...more >>
Error with SQL in Backup Exec Posted by jgervais at 5/20/2006 9:43:17 AM I have SQL 2005 installed on a Windows 2003 server. I have installed Backup
Exec 10d and get an error when trying to backup the SQL database. When I go
to create a new backup job I can see the two databases ( one for Backup Exec
and the other one for Solid Edge Insight Server and Sharepoint)....more >>
SQL Job Access Rights Posted by Mail at 5/19/2006 10:43:19 PM Do you guyz know what rights are needed to run a SQL job?
I have a friend that took away SA rights to a user and that user has dbo
access to the database, but can't run the job anymore.
What I think it is, they don want to give full SA rights back to the user.
Any suggestions or leads?
...more >>
SQL 2005 with Backup Exec 10d Posted by microsoft at 5/19/2006 3:16:08 PM I have SQL 2005 installed on a Windows 2003 server. I have installed Backup
Exec 10d and get an error when trying to backup the SQL database. I can
see/backup the Backup Exec database but when I try to click on the other
database
( used for Sharepoint and Insight ) it gives me this error...
...more >>
change object owner with a wildcard Posted by SAC at 5/19/2006 2:15:34 PM I'm trying to use sp_changeobjectowner
I'd like to change the owner on all table names that begin with "tbl".
sp_changeobjectowner "tbl%", "Sam" doesn't work.
what do I need to change?
do I need to label it "dbo.tbl%"?
Thanks.
...more >>
ASP pages and SQLServer 2000 database Posted by James_101 at 5/18/2006 10:56:01 AM My computer-based training piece sends user data to asp pages which relay the
data on to a SQLServer 2000 database. All works well with one exception:
when a new record is created, any spaces in the string containing the user's
name are deleted.
When the training piece sends the variable ...more >>
Import/Export Problem Posted by Jonathan Grant at 5/18/2006 12:00:00 AM I have SQL Server 2005 Developer Edition, I am currently in the process of
installing SP1, on XP SP 2.
I have looked through previous posts here concerning import/export and have
worked out that I need SSIS, but it doesn't appear to be installed on my
machine. I have Configuration Tools, An...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
INSERT INTO Query Posted by RC- at 5/17/2006 2:12:17 PM I have a list of values that I need to insert into a SQL table. The list of
values is stored in a .txt file. What would be the syntax of the insert into
query be and how would I reference the .txt file. Or, is there a better way
to get the values added to the table?
TIA,
RC-
...more >>
Problems restoring from "File or Filegroups" backups Posted by Conan Kelly at 5/17/2006 10:12:33 AM Hello all,
Using SQL Server 2000 (Standard Edition, I think)
I was under the impression that File or Filegroups backups just backed up the data file at that point in time and that the log files
were insignificant. Apparently I was wrong and now I'm having trouble trying to get the DB operat...more >>
Installing SQL on XP Posted by Jan Il at 5/16/2006 5:27:55 PM Hi all...
Another question, can I install the SQL Server 2005 Express Edition on my XP
Pro SP2? Are there any preliminary requirements that I need to look at
before doing so?
Jan :)
...more >>
New to SQL Server Posted by Jan Il at 5/16/2006 5:22:25 PM Hi all :-)
Do I need to have a server in order to learn how to use the SQL Server 2005?
Jan :)
...more >>
Prevent Transaction Logging Posted by Tom Gaughan at 5/16/2006 12:43:00 PM We have pharmaceutical databases that get purged and repopulated nightly.
The tables range from 20K+- records to 55K+- records. Before these
maintenance routines (stored procedures) run we'd like to disable
transaction logging and then enable after completion.
Thanks in advance...Tom
...more >>
Run Query using Dates Posted by RC- at 5/15/2006 10:12:15 AM I need to run a query that will pull all of the data with in a certain date
range. I can't seem to figure out the syntax for the query in SQL. In MS
Access, this query works perfectly:
SELECT MASTER_APM_VENDOR.Vendor, MASTER_APM_VENDOR.Name,
MASTER_APM_VENDOR.Last_Inv_Date
FROM MASTER_APM_...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |