Can someone please explain me the internals of SQL Server replication. I need to know what happens when a new data is inserted, which all views and triggers get initiated and how the whole process works. Thanks.
I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in...
SQL Server administration, SQL Server 2005, Database backup and recovery
Hello I have a 250GB database and the auto create statistics is on is that a good thing? Software/Hardware used: sql server 2005
SQL Server administration, SQL Server performance, SQL Server performance tuning
I have a sequel db of users which is periodically updated by exporting to access, making changes, then re-importing amended table. After re-importing, the records are duplicated, and the autosequence jumps to over 10,000. I only have 682 records. (That is the highest index number used.) Why does...
When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner "domainrmartinez". How can i restore a database from server1 to server2 and the database owner as "sa"? Software/Hardware used: SQL Server 2005
SQL Server, SQL Server administration, SQL Server database restore
Does a list of Transact SQL statements, that cannot be used within transactions, exist please? Is it available on the Web? Software/Hardware used: Windows PC, SQL Server 2005
Is there a way to see who created or droped a table in sql server?
SQL Server management studio will no longer run on my client PC. It ran fine for about 12 months, but now warns with: Evaluation Period has expired..... I am only running the mgmt piece only. How do I get this ability back on my pc?
how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?
I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ), FILEGROUP...
SQL Server 2008 training, SQL Server 2008 error messages, SQL Server 2008
I'm a new babie in the use of SQL server. Infact i've never used it though i use SQL and Mysql but just as a beginner. Now i find myself in a company where I have to create a database for 180,000 records. whereas, each of these records have 5 documents to be attached against it. Please how can i...
I try to add a new server registration using Enterprise Manager in a client machine to the SQL database in the server machine. I somehow keep getting 'Access denied' or registration failed. Then I can finally add the server registration after I open the shared folder at the server. Can anybody...
SQL Server Enterprise Manager, SQL Server registration, SQL Server administration
How can I access a SQL Server without a password, how can I change a SQL Server password, and what is an SA on a SQL Server?
SQL Server security, SQL Server administration, SQL Server Password Management
Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data...
SQL Server performance, SQL Server maintenance, SQL Server administration
I am upgrading my firm’s legal software to a version that uses SQL Server 2005. We are on a Windows 2003 Small Business Server, and SQL Server was installed before I started at this firm. My new software needs me to login as the System Administrator. I cannot seem to do that, as I do not know...
Is there any way to set Password expiration Policies on SQL Standard Users in SQL 2000?
SQL Server 2000, SQL Server administration, SQL Server security
Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do this in T-sql like an SP or a...
Hi My daily maintenance job fails due to the below error from last 20 days regularly Executing the query "BACKUP DATABASE [shipment] TO DISK = N'D:\backup\shipment.bak' WITH NOFORMAT, NOINIT, NAME = N'shipment', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Write on...
How do I set the username and password in SQL Server to allow connection to the database?
SQL Server, SQL Server administration, SQL Server authentication
How can I implement indexed views on our SQL Server? Is there an example that shows how they would improve query performance?


