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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|