all groups > sql server misc > february 2004
how to create cursor which holds data and then available in layout's data environment ?
Posted by mac at 2/26/2004 5:03:39 PM
I am using SQL2K as backend and vfp6 as frontend.
How can I save my selection of records into cursor and then make it
available in my layout's data environment ?
Any suggestion ?
Thx
... more >>
database design question
Posted by facetoface72 NO[at]SPAM hotmail.com at 2/25/2004 6:25:13 AM
Hi,
I have a database which currently has a 'Clients' table which contains
the NT User Id, Full Name, and Department of each user in the company.
It gets imported at the end of each month, but this is where the
problem comes in.
Let's say I have a table that reports phone calls by each user... more >>
Security
Posted by Harry Chance at 2/23/2004 1:56:14 AM
Hi, I'm experimenting with SQL security, creating users and access
privileges, and so on. I'm using the 'pubs' database for practice.
I've set the 'public' role to REVOKE all permissions on the table
'authors', (At least I think it's revoke - the box is empty, no tick or
cross appears)
... more >>
Transfering data from SQL to MSDE
Posted by TWiSTeD ViBE at 2/20/2004 2:46:18 PM
Hi,
When i try to import a database from my SQL server on the web it says my
licence wont let me use data transformations - is there any other easy way
to get the data across to my development server?
Thanks in advance folks,
twisted
... more >>
Reporting Services install
Posted by Wilhelm_vHS NO[at]SPAM hotmail.com at 2/20/2004 12:23:30 PM
Hi there
I'm trying to install Reporting Services evaluation version. It comes
up with message "ASP.NET is not installed or is not registered with
your Web Server. ASP.Net is required for the Report Server and the
Report Manager components." when it is checking for the system
prerequisites.... more >>
a question for setup experts please
Posted by tracy at 2/13/2004 7:53:32 PM
hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is ther... more >>
RESTORE DATABASE question
Posted by shaab.mohagir NO[at]SPAM bonbon.net at 2/12/2004 12:13:16 PM
Hello,
I ran the script bellow, then the statsales datbase log and data
"logical" file names changed to those of the database
'statsales_staging_victory_full' which I restored from as shown in the
script bellow.
The questions are:
Do I have one chared log file now, for both statsales and... more >>
Developer Edition 2000 - Enterprise Manager
Posted by Jeremy Collins at 2/12/2004 8:29:55 AM
Hi all,
Just a quick question, does SQL Server 2000 Developer Edition
come with Enterprise Manager?
--
jc
Remove the -not from email... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Good example of Excel to SQL Server writeback samples
Posted by belindacur NO[at]SPAM yahoo.com at 2/6/2004 7:09:50 AM
Can any of you please point me to some good samples on Excel to
SQL Server tables writeback templates or samples.
Thanks
Belinda... more >>
Database permission error
Posted by Taishi at 2/5/2004 10:14:18 PM
Andy,
I am new to SQL. It was hard just to figure out how to install it.
I know I am logged in as a Admin. in Windows.
I have the little server box with the round circle on it in the bottom right
corner(toolbar). The SQL Server Service Manager.
I tried to search for the sp_helpsrvrol... more >>
Restore Problems
Posted by Séan Connolly at 2/3/2004 4:41:17 PM
We had a database with lots of backups going back 6 months or so. Someone
dropped that database and we now only seem to have one backup available.
I presume this is something to do with the log being deleted. Is there any way
to get my list of backups back ????
Please help !!!!
S
... more >>
Design Question: Calculated Field
Posted by imani_technology_spam NO[at]SPAM yahoo.com at 2/3/2004 7:38:55 AM
I'm trying to create an OLAP system using SQL Server 2000 Analysis
Services (AS). I want the AS cube to be based on a database with a
star schema.
I have a field called Ratio. The initial ratio value is based upon
this formula: (CurrentTimePeriodAmount -
PreviousTimePeriodAmount)/PreviousTi... more >>
Formating a field in a view
Posted by Hallgeir at 2/2/2004 8:54:45 PM
I have a SQLServer2000 database in which I have created a view. I want
to convert numeric values in a colum to string values, straight forward.
Example: the number 25 I want to convert to the string 25, number 7 I want
to convert to the string 7 and so on, and most import I want to convert 0 to
... more >>
|