|
SQL Client Tools on MSDE - Database Maintenance Plan
Hy
anyone use 'Database Maintenance Plan' for setting database backup?
I try many times but the backup's log mangement don't work.
Giuseppe
...
Wed, 7 Jul 2004 09:22:12 +0200
|
Restricted access to Enterprise manager
Hi,
I want to restrict the access to enterprise manager from the developer
computer. They need the access the develpment machine so they require
enterprise manager on their machines. But i do not want them to access
the production database from their workstation enterprise manager. Also
because they are develo ...
Tue, 06 Jul 2004 13:13:55 -0700
|
Where can I find the source code for dateadd T-SQL function
Where can I find the source code/ pseudocode implementation of dateadd T-SQL function
Thanks in advance
Kiran ...
Tue, 6 Jul 2004 09:06:02 -0700
|
Will Highly Appreciated
I would highly appreciated if any body write step by step command of making
one database with three filegroup and backup of only single file group and
restore that filegroup instead of whole.
Thanks
NOOR
...
Tue, 6 Jul 2004 15:42:26 +0500
|
sq select problem
can anybody help me with sql problem
if have this table `link_item_cato`:
+-----+---------+---------+
| id | item_id | c ato_id |
+-----+---------+---------+
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 1 |
| 4 | ...
Mon, 5 Jul 2004 15:28:05 +0200
|
Recovery
Dear Guys...
Let's assume I have a Database Name "Production" and I have two Harddisk C
and D. In C drive I have production.mdf file and in D Drive I have
production.ldf. After a month C drive has been corrupted but D drive is
still live so now I am in a position to recover whole data or not through
producti ...
Mon, 5 Jul 2004 18:23:21 +0500
|
Diff between xxx_data.mdf and xxx.mdf files
What is difference between "xxx_data.mdf" and "xxxx.mdf"? IN Sql2k, I =
created, attach and detach database manytimes. SOme time its shows the =
database file name as "xxx_data.mdb and xxx_log.mdb" and sometimes it =
only shows file name as "xxx.mdf and xxx.ldf", why? However in =
Enterprise manager it shows dat ...
Mon, 5 Jul 2004 17:24:30 +0530
|
Cannot execute through ISQL
Hi,
I cannot execute ISQL query from dos prompt to one
specific MS SQL Server 2000 production machine, but works
fine with other server any reason
Please let me know ASAP
Thanks & Regards,
Mustaq ...
Mon, 5 Jul 2004 02:24:38 -0700
|
Third time Posting
I have created one database named test on DServ Server and in that database
I have created three fileGroup named Primary, BaseFileGroup,
TransactionFilegroup and after that I took the backup of that all filegroup
and restore it into another server. (OServ). After a week I took only the
backup of TransactionFile ...
Mon, 5 Jul 2004 11:06:27 +0500
|
client license problems...
dear all,
our company using sql 7.0 with 10 cal on the production.
before we use win95 with client program which developed by internal staff
connect to the server.
it works fine without any "license insufficient " warning.
but after upgrade all machine to winxp. those machines oftenly show
"insufficent ...
Mon, 5 Jul 2004 11:07:39 +0800
|
Client license question
Hi all,
This is a question related to licensing...
Environment :
Server 1 - Windows 2000/2003 with SQL Server 2000
Server 2 - webserver (IIS/Apache/etc)
Server 2 is connecting to the SQL Server database (Server
1) using SQL Server authentication (i.e.
SQLServerAccount/Password)
There are ...
Fri, 2 Jul 2004 12:35:22 -0700
|
where to download client utilitie for MS SQL 2000?
Hello,
we host some MS SQL Server databases.
Our SQL server is accessible via port 1433 from outside.
And i was wondering how our clients can connect to our SQL Server
withouth having their own license of MS SQL 2000 server.
Is there a free downloadable client tool so they can log in with their
account on ...
2 Jul 2004 06:54:12 -0700
|
where to download client utilitie for MS SQL 2000?
Hello,
we host some MS SQL Server databases.
Our SQL server is accessible via port 1433 from outside.
And i was wondering how our clients can connect to our SQL Server
withouth having their own license of MS SQL 2000 server.
Is there a free downloadable client tool so they can log in with their
account on ...
2 Jul 2004 06:53:54 -0700
|
SQL Client Tools for SQLXML on Win2k3 Web Srv
Hello,
Has anyone figured out a way to install SQLXML on Web
Server Edition? I tried and it says I have to have the
SQL 2K client tools.. well I can't install them because
that setup has been disabeled because it is the web server
edition (which I understand). But shouldn't a stand alone
web server s ...
Thu, 1 Jul 2004 11:08:37 -0700
|
current database name
What application are you using? How are you connecting to
the database?
>-----Original Message-----
>How I know the current database name in which currently I
am standing... any
>system level funtions
>
>Thanks
>
>Noor
>
>
>
>
>
>
>.
> ...
Thu, 1 Jul 2004 08:34:57 -0700
|