Description:
Microsoft SQL Server newsgroup.
|
|
|
Transaction log file
|
| |
How can i delete a transaction log file in sql server 2005 I need to delete an old and big file and create a new one with default size Thanks SA
|
|
|
notification services and a web service
|
| |
Hi im currently investigating a project using notificiation services and web service technologies. My question is that is it feesible for the following 1. client sends XML doc through webservice 2. data is stored in database 3. when data changes (i.e. entered quote for insurance goto to the offering... more »
|
|
|
Not an NS 7 database
|
| |
I am currently using a MS sql server 2005 database for Dell Openmange. When I do an install of The newest Dell Management console on a new win 2003 server and try to attach to this new database I get the following error. 'The database 'ITAssist' selected on the SQL Server specified is not an NS 7 database. Please change your selection to specify an... more »
|
|
|
Need more information about SQL job that fails
|
| |
hi I have a string of jobs that execute in sequence. From time to time I will find my SQL server unresopnsive. Screen saver frozen, no reponse with keyboard/mouse. I have been forced to use power button to restart the server. No pattern as to when or why.......except its the same job at the very same... more »
|
|
|
Bug: "Dynamic MDX Queries" don't work as described
|
| |
In short, "Dynamic MDX Queries" don’t work as described in the BOL. I’ve lifted the sample code directly, tried to run it, and it fails. It’s documented at [link] The “Analysis Services Event Provider” queries a SQL table, generates XML output, passes it through an XSLT style sheet, and generates an... more »
|
|
|
SMTP authentication
|
| |
Our SMTP server requires authentication and I cannot find where in NS, SMTP authentication can be configured. Several hours of googling have also lead nowhere. From what I can tell, to use NS to send external emails, the email server must allow relaying from the NS server (that will not be allowed).... more »
|
|
|
Notification Question
|
| |
HI, I am using SQL 2005, I have a question regarding notification, our SQL 2005 has a curitial role in our enviorment, that is why I would like to get a E-mail notification, when ever mssql service or sql agent service crached. I did configuer SQL mail, but it is not possible to achieve what I want with... more »
|
|
|
Clustering Notification Services
|
| |
Hi, We are trying to install the Notification Services on a SQL 2005 Failover Cluster. We are using the following MS documentation: [link] The following is not clear to us: during install of the Notification Services, where do I install the application executables, what is the... more »
|
|
|
|
