DB Engine - SQL Server

Thread preview

Thread	Last Post	Replies

log shipping question	07 Mar 2008 10:10 GMT	6
Log shipping from sql 2k to sql2005. How do I do it? I have sql2005 reporting server need to be synched with sql2000 prod db for reporting. How do I make the dbs synched?
Linked server to Access database	07 Mar 2008 08:06 GMT	16
I need some help getting a linked server working to an Access database from SQL Server 2005. First off, here is the error I'm getting =======================
BI	07 Mar 2008 07:52 GMT	2
I already have sql2005sp2 but I don't see the Business Intellegence piece loaded. Where do I find that just to download and install. Thanks.
not being able to restore through Enterprise Manager	07 Mar 2008 07:33 GMT	1
We have a client on SQL 2000 version 8.00.2039. When we conduct a manual restore of a database, we cannot do so by right-clicking on that database in Enterprise Manager. Enterprise Manager freezes when we choose All Tasks...Restore. So, we end up having to instead run a script ...
Naming Convention	07 Mar 2008 02:19 GMT	4
Where can I find SQL Server 2008 (or 2005) naming convention and coding practice recommanded by Microsoft? Thanks Quinn
permissions MDF LDF	07 Mar 2008 00:39 GMT	1
Hi all My question is , What permissions do you grant to the MDF / LDF files , bear in mind I want maximum security all the best !
DBA question	06 Mar 2008 23:18 GMT	1
My netwrok admin told me taht I am not allowed to console the SQL server as a dba. SQL server manager clinet installed in my computer is the only toll that I cound do to manage the databases.
Plan Guide	06 Mar 2008 22:50 GMT	2
Is it possible to do something like this with a query plan? I want to get Query1 select * from tableA
Distribution Database	06 Mar 2008 22:17 GMT	3
Can I move the Distribution Database from one location to another without impacting replecation.? Thanks
Alerts to be emailed to our team	06 Mar 2008 21:18 GMT	1
We have a few procedures we want to monitor for issues... and want to know how to enable alerts to notify our team when there is an issue.. We have error logging enabled within the procedure.. which is writing the errors to a table, but unless we go out and view that table we dont ...
double-take for high availability?	06 Mar 2008 18:41 GMT	2
has anyone used double-take for high availability solution? i am interested in product short comings and pitfalls when used in conjunction with sql server. thanks, gigel
Removing AD from server with SQL on it	06 Mar 2008 17:23 GMT	1
I've got a situation where I need to move a server (server A) from the domain (Domain A) that it is in (it is the only server in this domain) into a different domain (Domain B). The curve ball is that SQL 2005 is set up on this server.
SQL Server X64 log shipping, bulk logged, index rebuild.	06 Mar 2008 16:49 GMT	1
SQL Server 2005 X64 sp2+ We need to minimize tran log growth during index rebuilds because the database is logged shipped. I know log shipping supports bulk logged recovery model and that index rebuild are minuimally logged in bulk logged
Help with agent job to import from ODBC?	06 Mar 2008 16:25 GMT	2
SQL Server 2005 Standard Edition. Using wizard, no problem to use SQL to import from ODBC data source. Saved the DTS job to an SSIS package, unable to use with agent scheduler. Error is DTS_E_PRODUCTLEVELTOLOW.
DTS packages migration from MSSQL 2K to MSSQL server 2005	06 Mar 2008 15:10 GMT	2
I need to migrate all my dts packages from sql server 2000 to sql server 2005 so I can access these packages under Legacy->DTS in Microsft sql server 2005 Management studio. How can I do this?