Viewing 15 posts - 766 through 780 (of 1,655 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.
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...
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...
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...
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.
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).
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
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...
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.
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...
August 19, 2008 at 6:12 am
Oeps,
the previous reply was meant for another post. Ignore it here.
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...
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...
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
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
August 13, 2008 at 7:04 am
Viewing 15 posts - 766 through 780 (of 1,655 total)