| Thread | Last Post | Replies |
|
| SQL Express Protocols | 31 Mar 2008 03:00 GMT | 1 |
What Protocols should be enabled using a local copy of SQL Express? Shared Memory Name Pipes TCP/IP
|
| Better to backup up all server databases or backup system databases separately from databases? | 31 Mar 2008 01:26 GMT | 1 |
Gurus, Running SQL Server 2005 SP2 and using named instances. I am having lots of important application databases on my server these days. My question is this. Is it better to back up all server databases in one maintenance plan
|
| Missing "Public" SQL Server 2005 role - but everything works fine. | 30 Mar 2008 22:13 GMT | 14 |
Gurus, Running SQL Server 2005 SP2 default instance on top of Windows Server 2003 SP2. Everything is working fine however I noticed that under server roles, the roles are all there EXCEPT for "Public". Really strange. Anyone ever
|
| SQL Server 2005 Transaction Log Autogrowth | 30 Mar 2008 19:28 GMT | 1 |
i´m trying to change this setting on the Sql Management studio database properties but it doesn´t let me. If i change it to unrestricted it automaticaly changes to restricted to a specific value. How can i change this??
|
| T-SQL to List Important SQL 2005 Objects | 30 Mar 2008 15:48 GMT | 2 |
I am wondering if anyone has created T-SQL that lists various categories of SQL 2005 objects that quickly lists them. For example, if I wanted to see all the system objects that were related to triggers or if I wanted to see all objects related to constraints. Basically a ...
|
| query to return week number 1 for first week of year starting on a monday? | 30 Mar 2008 12:33 GMT | 1 |
I'm trying to put together a query that will return number 1 for the first week of the year that starts on a monday. I've found the following query: select datepart(week, DateAdd(day, -1 * DATEPART (dw, '06-JAN-2008') -1, '06-JAN-2008' ))
|
| SSIS | 30 Mar 2008 12:08 GMT | 1 |
In my envrionment not all the tables have datetime field that indicates when the row is created or updated. Coming up a DW project that will be implemented I would like to ask the community what kind of techniques they use for Incremental data loading. There are some
|
| Exporting SQL Server Data | 30 Mar 2008 12:06 GMT | 1 |
We are migrating our website to a new hosting site. The site has a CMS written in C# with a SQL Server backend. I need to migrate this but the new hosting site will not allow me to restore the SQL Server from backup at the new site and requires that I import CSV files.
|
| Differential maintenance in plan sql 2000: setup | 30 Mar 2008 08:55 GMT | 1 |
I'm trying to setup a differential maintenance plan to backup all users databases on sql 2000 using t-sql (or not) I can't figure out or find how to include "all user databases" like i would using a maintenance plan. This is a cake to do in sql 2005 but
|
| querying different databases | 30 Mar 2008 07:25 GMT | 22 |
I need to query different databases. Below is an example (the database name is returned in 'select dbname'): select dbname, (select count(*) from [dbname].dbo.members) as 'mycount'
|
| Edit a dataset | 29 Mar 2008 21:28 GMT | 2 |
I want to query a set of tables in order to create a dataset that I can look at (in a grid in my application) and decide manually whether I want to include the records for further processing such as including in a report. I thought to have a bit field which I can treat as a ...
|
| security for function execution on sql server 2000/2005 | 29 Mar 2008 14:56 GMT | 1 |
I have encountered a strange security problem recently, I send sql server functions to my clients and when they install them, it seems execute permissions are turned off by default (at least this happened to 2 of my clients: they encountered lack no execute permissions on those ...
|
| SQL Server Log | 28 Mar 2008 22:33 GMT | 8 |
Where can I query the SQL Server Log? I'd like to see the Database Mirroring entries using T-SQL, not the log viewer. Thank-you, Rubens
|
| Monitoring database space usage | 28 Mar 2008 20:56 GMT | 2 |
I'm interesting in monitoring database space usage in SQL Server 2005. Ideally, once a day I'd like a job to run that looks for databases that are within 20% of capacity. If one or more exists, I get an email. I don't need/want it to monitor constantly as our business processes ...
|
| How to get details of when Database was last used | 28 Mar 2008 20:31 GMT | 3 |
I want to find out on when the database and the objects were last used so that we can do some cleaning up and sent it for archiving... Thank You Rgds,
|