Viewing 15 posts - 766 through 780 (of 1,654 total)
Is the SQL Browser service started?
If I remember correctly you need to use the browser service when you use a none default port number.
[font="Verdana"]Markus Bohse[/font]
August 22, 2008 at 4:08 am
How do you want to store the data in SQL server? Do you just need to place the whole xml document into a text or varchar column or do you...
[font="Verdana"]Markus Bohse[/font]
August 22, 2008 at 2:46 am
The Auditlevel is set in a registry key. You can change it programmatically by running this
EXEC master..xp_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer',N'Auditlevel', REG_DWORD, 2
In case you use a named instance use...
[font="Verdana"]Markus Bohse[/font]
August 22, 2008 at 1:02 am
When you design a report you can define the page size.
Under report properties you will see Interactive size, which is the page size used in when running it from...
[font="Verdana"]Markus Bohse[/font]
August 22, 2008 at 12:32 am
You cannot install standard editon on Vista. Use Developer Edition or a virtual machine with a server OS.
See here which OS are supported for Standard Edition.
[font="Verdana"]Markus Bohse[/font]
August 21, 2008 at 8:42 am
Yes you can have SQL 2000 and 2005 on the same clustered server, but each of them has to have it's own cluster group and disk(s).
[font="Verdana"]Markus Bohse[/font]
August 21, 2008 at 1:07 am
You can either use sqlcmd.exe to execute sp_readerrorlog or simply use a TYPE command command to open the file. Something like TYPE C:\Mssql.1\Log\Errorlog
[font="Verdana"]Markus Bohse[/font]
August 20, 2008 at 1:15 am
If you look at the options you have with defining a datasource you basically have 4 options.
1. Supply credential interactively when running a report, which menas the user have to...
[font="Verdana"]Markus Bohse[/font]
August 19, 2008 at 7:09 am
Jack is right.
SQLH2 can monitor all these things and they even offer a set of reports. See here for the main download and here for the reports.
[font="Verdana"]Markus Bohse[/font]
August 19, 2008 at 6:57 am
The credentials which are used when you view a report depend on the configuration of the datasource. It could be set either dynamically during execution or a fixed username and...
[font="Verdana"]Markus Bohse[/font]
August 19, 2008 at 6:12 am
Oeps,
the previous reply was meant for another post. Ignore it here.
[font="Verdana"]Markus Bohse[/font]
August 19, 2008 at 6:12 am
The credentials which are used when you view a report depend on the configuration of the datasource. It could be set either dynamically during execution or a fixed username and...
[font="Verdana"]Markus Bohse[/font]
August 19, 2008 at 6:10 am
Could you explain a bit more what you mean with "the deleted stored procedure".
Are you looking for info about who and when a stored procedure was deleted, then have a...
[font="Verdana"]Markus Bohse[/font]
August 19, 2008 at 1:14 am
You can change the name of the default site or any other setting through the "Report Server Configuration" utility.
Look in your Programs Menu under SQL 2005>Configuration Tools
[font="Verdana"]Markus Bohse[/font]
August 13, 2008 at 8:14 am
Did you have a look at Visual Studio for DB Professionals?
You can find some info about the latest version here
or about the 2005 version here
[font="Verdana"]Markus Bohse[/font]
August 13, 2008 at 7:04 am
Viewing 15 posts - 766 through 780 (of 1,654 total)