|
Installing SSRS over another server within the same domain Hi all; how much it�s possible to install the SQL-Server 2005 DB engine over one server and the SQL-Server 2005 reporting services (with the analytical services) over another server within the same domain/LAN. Thanks in advanced ... 5 Jul 2008 23:45
creating a new database Hi, I've installed a Visual Studio 2008CD and found out that the SQL is installed as well,now i need to create a new datbase using SQL ,I go to propgrams>SQL Server 2005>Configuration tools then i have three icons : * SQL Server Configuration Manager. * SQL Server Error and Reporting usage. * SQL Server Surf... 6 Jul 2008 11:57
Running Windows Application over VPN "JIM.H." <JIMH(a)discussions.microsoft.com> wrote in message news:6158AED7-9BC4-4F04-9245-07668C4244F2(a)microsoft.com... Running Windows Application over VPN I have a windows application that uses SQL Server as backend.I need to install this application to another network and make our users access it. I ... 6 Jul 2008 17:05
Q: Running Windows Application over VPN Running Windows Application over VPN I have a windows application that uses SQL Server as backend.I need to install this application to another network and make our users access it. I have two options: 1. Do remote desktop to remote network over VPN and run application. 2. Install application into our network an... 5 Jul 2008 08:26
Enabling AWE SQL Server 2005 64-bit Hi Christian, can you please point to me the link regarding this? "... a fairly recent Microsoft best practice but guidance has just changed over the last few days. The best practice now is only to enable it to if you see the "paged out" error message in the log." Thank you, Vivien Xing ... 4 Jul 2008 23:18
Enabling AWE SQL Server 2005 64-bit - multipleinstances I am very interested in this discussion. I would like to learn from you all about the guideline for min/max memory configure for multiple instances. My server is SQL2005 64-bit, with 36 GB memory and 16 named instances. Any suggestions or best practices to follow? Thank you, Vivien Xing ... 4 Jul 2008 23:18
Current Job Run Status I am trying to create a query against a SQL 2000 database to see if a job is currently running. I cannot cancel the job that I am monitoring. Shortly after it completes, I need to notify some people and do some additional work. Unfortunately I forgot to change the job to notify me on completion, so I just want to se... 5 Jul 2008 04:22
select statement with no results is producing locks If I have a select statement that produces no results, what sort of locks could it still potentially generate? ... 4 Jul 2008 14:07
Result Set from RESTORE FILELISTONLY into #table? Hi, If I have a table called tblEmployee with columns of diffeernt types, I can do something like this SELECT * INTO #foo FROM tblEmployee; and it will create #foo with all the correct column types and insert the data. I do NOT have to create the table definition first. I now want to do the same with the... 6 Jul 2008 02:48
SQL server transaction timeout and stored procedures Hi, is there a default transactions timeout when running stored procedures? Basically I need to run stored procedures that could involve 100,000s of inserts\updates and I want to be able to let the procedure run until these are completed. Is this feasible or are there some restrictions. Also is there anythi... 4 Jul 2008 13:05
New SQL Security problem coming next Tuesday Hi, Yesterday's Security Bulletin Advanced Notice http://www.microsoft.com/technet/security/bulletin/ms08-jul.mspx talks about a patch coming for SQL 7/2000/2005. Wonder if this will be in CU9 for SQL2005? If it is extra to CU7 for SQL2005 it will make my life more complicated as we are just about to put CU7... 4 Jul 2008 18:12
Script to get DB space usage Info. Hi All, I am looking for a Script which will give me complete space usage information of a particular DB in SQL Server 2000. It would be of great help if I get the script which will give same results as we get in Database diagram. Thanks in advance. Thanks & Regards, Sajid C. ... 6 Jul 2008 01:47
SQL 2005 - Not responding - freezing Hi, I have SQL Server 2005 Standard on a Windows Server 2003 64Bit Operating System, Dell PowerEdge2900 with 8GB RAM. Once in couple of months, the SQL Server just stops responding for my client requests which my application uses as a backend database. The memory usage of SQL Server goes as high as 4GB out o... 4 Jul 2008 10:00
SQL 2008 Policy management through sql queries Hi folks, i was wonderign .. is there a way how to find out in which facet is a searched property through some SELECT from a dmv maybe? Eg. in which facet is a property ClrEnabled (its in surface area config) but through some query Thx, Marek Chmel ... 4 Jul 2008 07:57
How to create SQL script of the existing table or database Hi! Is there a way to create a script from the existing database, Adventure Works for example? I mean, some way to export not only a table structure, for example, but also data into a sql script, so that if I run it, it will create me both table and insert all data. Is it possible to script the entire databa... 6 Jul 2008 01:47 |