Groups | Blog | Home


Archived Months
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
all groups > sql server (alternate) > october 2004 > threads for october 29 - 31, 2004

Filter by week: 1 2 3 4 5

Terminology question - set of related records in multiple tables
Posted by Steve Jorgensen at 10/31/2004 10:27:56 PM
Terminology question: Is there a term for a set of records related directly or indirectly by key value in several tables? For example, a single invoice record and its line item records -or- a single customer, the customer's orders, the order lines for those orders, the customer's invoices, an...more >>


Newbie backup Question
Posted by Fred at 10/31/2004 2:58:19 PM
I have a table in sql 2000 that is storing Financial Tick data. The database size now appears at about 30GB and I have decided to backup the database and store the data offsite. Here is where I am confused about whether only a Database (complete) backup is necessary or whether I must also incl...more >>

Report Services Examples.. please.. VS.NET
Posted by Karina Gamez at 10/30/2004 5:07:18 AM
Hi.. Im newbie on Report Services with VS.NET... I made a cube on olap.. and I try to lear some mdx for my reports.. But, in the report designer... I need a lot of help.. Please.. anybody.. can help me¨?? Thanks a lot...! Karina Gamez *** Sent via Developersdex http://www.de...more >>

How to upload table to sql?
Posted by Evgeny Gopengauz at 10/30/2004 5:07:17 AM
How to upload a content of a table into sql-file (the set of INSERTs) using standard MSSQL utilities? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

How to upload a table as sql?
Posted by Evgeny Gopengauz at 10/30/2004 5:07:17 AM
How to upload a content of a table into sql-file (as a set of INSERTs) using standard utilities? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

How to find out workstation name from net_address
Posted by ericyang1991 NO[at]SPAM hotmail.com at 10/29/2004 4:23:40 PM
Hi, Is it possible to know workstation name from data in column net_address from master..sysprocesses? TIA...more >>

Selecting All Parents in a Path Enumerated Tree
Posted by nutgg001 NO[at]SPAM sneakemail.com at 10/29/2004 3:02:21 PM
Hi, I have a tree structure which is maintained through the use of a path enumerated column: CREATE TABLE items ( item_id NUMERIC NOT NULL, path VARCHAR2(64) NOT NULL ); The path is is a colon separated list of ids of the nodes of the tree. So, for example, in this structure: 0 ->...more >>

Newbie help: sql string conversion
Posted by steve at 10/29/2004 2:37:25 PM
Hi, I am trying to avoid a horrendous amount of coding and see if i can get away with a complex sql statement. I have data values (measurements) which I have stored in the database in the form of STRING so that i can keep the original format. They look like this: 000078 -> 7...more >>



Problems with MSDE
Posted by Markus Graf at 10/29/2004 12:18:19 PM
Hi all I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation was not the problem, but if i would connect with a client like dbamgr2k or the MS Enterprise client, the client hangs up. If i try a nonlocal server, it hangs too. What's the problem? Markus...more >>

View stored procedure permissions
Posted by tcaylor NO[at]SPAM thomasnelson.com at 10/29/2004 11:15:54 AM
We are running SQL Server 2000 Developer Edition. I don't want to make the developers the sysadmin or even the dbo in the user databases. Is there a way to give them access to only view the permissions for the stored procedures in the user database without making them dbo? When I take them...more >>

checkpoint command and backup log
Posted by louisducnguyen NO[at]SPAM gmail.com at 10/29/2004 9:51:35 AM
This is maybe a dumb question but I couldn't find a definitive answer on BOL. Looking at my backup script. If I issue a CHECKPOINT, does this truly force all transaction log entries to the data file? Therefore, making it unnecessary to BACKUP log (just BACKUP database is needed). Louis...more >>

Still Trying to Figure Out Identification of SQL Server Stored Proc. Permissions via VB
Posted by bmccoll1 NO[at]SPAM midsouth.rr.com at 10/29/2004 7:30:59 AM
I've looked through many suggestions and partial examples all over this newsgroup and still am not coming up with anything that does specifically what I'm wanting to accomplish. I'm writing a VB 6.0 application which uses SQL Server as the back-end. Here's an example of what I'm wanting to ...more >>


DevelopmentNow Blog