Can we do Even Programming in MS SQL 2005 Reporting Services ?

Hi,

Can anyone help me in this ?

Can we do event drive Programming things only in SQL 2005 Reporting Services without using VB.net ?

I want that on mouse move event or on focus on some particular cell of table or matrix a hidden picture or graph is visible.

I am using DUNDA's Plugins in my report.

Can anyone tell me how i can do this ?

RS_DBA

Do you have Visual Studio 2005? You can do event driven programming with that and use the report viewer to show your SQL reports. It allows you to easily create a front end for you reports.|||

Hi,

This is my limitation i have to use only SQL 2005 reporting service.

Can we backup to a remote drive?

Please let me know. Can we backup SQL Server database to a network drive?Yes.
From the backup command you'll want to use a UNC drive reference such as
\\servername\share
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?|||Yes, and you must use UNC format, not mapped drive.
btw, you still keep the tie?
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?|||"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uGmoZZaHEHA.3240@.TK2MSFTNGP12.phx.gbl...
> Yes.
> From the backup command you'll want to use a UNC drive reference such as
> \\servername\share
Providing it's a disk share. Tape drives must be locally connected
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 08/04/2004|||Hi,
There are Few Pre requisites to do this;
1. Should have share in the remote machine
2. You Should start SQL server using Domain user who got access to remote
machine Share
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?sql

Can we backup to a remote drive?

Please let me know. Can we backup SQL Server database to a network drive?
Yes.
From the backup command you'll want to use a UNC drive reference such as
\\servername\share
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?
|||Yes, and you must use UNC format, not mapped drive.
btw, you still keep the tie?
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?
|||"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uGmoZZaHEHA.3240@.TK2MSFTNGP12.phx.gbl...
> Yes.
> From the backup command you'll want to use a UNC drive reference such as
> \\servername\share
Providing it's a disk share. Tape drives must be locally connected
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 08/04/2004
|||Hi,
There are Few Pre requisites to do this;
1. Should have share in the remote machine
2. You Should start SQL server using Domain user who got access to remote
machine Share
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?

Can we backup to a remote drive?

Please let me know. Can we backup SQL Server database to a network drive?Yes.
From the backup command you'll want to use a UNC drive reference such as
\\servername\share
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?|||Yes, and you must use UNC format, not mapped drive.
btw, you still keep the tie?
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?|||"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uGmoZZaHEHA.3240@.TK2MSFTNGP12.phx.gbl...
> Yes.
> From the backup command you'll want to use a UNC drive reference such as
> \\servername\share
Providing it's a disk share. Tape drives must be locally connected
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 08/04/2004|||Hi,
There are Few Pre requisites to do this;
1. Should have share in the remote machine
2. You Should start SQL server using Domain user who got access to remote
machine Share
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"Bill Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:25D36DC8-F721-460B-9A81-D259078DED22@.microsoft.com...
> Please let me know. Can we backup SQL Server database to a network drive?

Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>|||That's right.

>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>
>

Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.
Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>
|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>
|||That's right.

>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?
|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>
>

Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>> SQL Server 2000 & 2005
>> When restarting a server, can you specify the size you want tempdb to be?
>> I have no choice but to place in on the same drive as the other .mdf
>> files and would like to avoid it being created in pieces.
>|||That's right.
>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>>I take it it will only do this if you have sized it manually, but will
>>shrink the tempdb if it had auto-grown?
>

Can SQL Database work as normal without the ldf file?

i got a prolem with the space of my C drive as the dadta bas eis too big for
it i am not a llowed to get a bigger disk drive but i am given another one
that means i got two small disk drives my data isn't inpputed fully into the
database and the disk drive is full . I check the mdf file and found out tha
t
the mdf file stands a smaller space compared to the ldf file .So i am
thinking of deleting the ldf file to make space or else what should i do? I
really need help .The quick answer is: Read up on Recovery Models, then when you understand
the risk, set the recovery model to simple. This will solve your transaction
log disk space problem but introduce a data recovery problem so you'll want
to make frequent back-ups.
-Paul Nielsen
SQL Server MVP
www.SQLServerBible.com
"Fairy239" <Fairy239@.discussions.microsoft.com> wrote in message
news:39E5ACBA-822E-43CB-BF99-9E8AB374228C@.microsoft.com...
>i got a prolem with the space of my C drive as the dadta bas eis too big
>for
> it i am not a llowed to get a bigger disk drive but i am given another one
> that means i got two small disk drives my data isn't inpputed fully into
> the
> database and the disk drive is full . I check the mdf file and found out
> that
> the mdf file stands a smaller space compared to the ldf file .So i am
> thinking of deleting the ldf file to make space or else what should i do?
> I
> really need help .|||
"Paul Nielsen (MVP)" wrote:

> The quick answer is: Read up on Recovery Models, then when you understand
> the risk, set the recovery model to simple. This will solve your transacti
on
> log disk space problem but introduce a data recovery problem so you'll wan
t
> to make frequent back-ups.
> -Paul Nielsen
> SQL Server MVP
i hope you can answer my qn and not asking me to read up stuff this stuff is
urgent need to besloved quickly i got a limit of time for completing the job
thank you
> www.SQLServerBible.com
>
> "Fairy239" <Fairy239@.discussions.microsoft.com> wrote in message
> news:39E5ACBA-822E-43CB-BF99-9E8AB374228C@.microsoft.com...
>
>|||No, the database can't run without an ldf file. Try moving either the ldf
or mdf file to the new drive - detach the database and then attach with
move. This article show how that works:
http://msdn2.microsoft.com/en-us/library/ms187858.aspx
http://support.microsoft.com/defaul...kb;en-us;818565
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Fairy239" <Fairy239@.discussions.microsoft.com> wrote in message
news:CCB6FE51-B406-4C6B-96BC-5116BDDA9E7E@.microsoft.com...
>
> "Paul Nielsen (MVP)" wrote:
>
> i hope you can answer my qn and not asking me to read up stuff this stuff
> is
> urgent need to besloved quickly i got a limit of time for completing the
> job
> thank you|||to truncate the transaction log try doing :
backup log database_name with truncate_only
then
dbcc shrinklog('Log_File_name')
do remember to take a back up of the db prior to doing this.
also read up the recovery models as stated previously.
Harshal Mistry
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message news:%23qFHtWtVGHA.5012@.TK2M
SFTNGP10.phx.gbl...
> No, the database can't run without an ldf file. Try moving either the ldf
> or mdf file to the new drive - detach the database and then attach with
> move. This article show how that works:
>
> http://msdn2.microsoft.com/en-us/library/ms187858.aspx
> http://support.microsoft.com/defaul...kb;en-us;818565
>
>
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Fairy239" <Fairy239@.discussions.microsoft.com> wrote in message
> news:CCB6FE51-B406-4C6B-96BC-5116BDDA9E7E@.microsoft.com...
>
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florence
Hi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>
|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>