SQL Server Administration

SQl Server Replication Internals

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.

Database restore

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...

Is having the auto create statistics on in a database a good thing?

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 autonumbering problem

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...

SQL Server Database Restore

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 transactions TSQL question.

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

SQL Server tables - What account created the object

Is there a way to see who created or droped a table in sql server?

SQL Server Management Studio

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?

SQL Server query

how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?

Errors creating database with SQL Server 2008 I&M Training Manual

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...

Attaching files to row information in SQL server

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...

Cannot connect to SQL Server via LAN

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 password issues

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?

Performance of very large SQL Server table with millions of rows

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...

Figuring out the SA password in order to upgrade to SQL Server 2005

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...

Password Policy for SQL Server 2000

Is there any way to set Password expiration Policies on SQL Standard Users in SQL 2000?

How to enable a trace for SQL Server Analysis Services using T-SQL?

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...

Database maintenance task (full back up) fails on SQL Server

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...

Setting a username and password in SQL Server

How do I set the username and password in SQL Server to allow connection to the database?

Implementing indexed views on a SQL Server

How can I implement indexed views on our SQL Server? Is there an example that shows how they would improve query performance?