Search Results | SQL Server Performance Forums

Linked Server Setup

Thread by: TRACEYSQL, Nov 14, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Im following this as i cannot get the linked sever setup http://www.databasejournal.com/features/mssql/article.php/3691721 I have selected the be...

SQLIO.EXE tool

Thread by: TRACEYSQL, Sep 5, 2007, 1 replies, in forum: Performance Tuning for DBAs

Im trying to figure out how to use the tool. I have documentation sqlio -KW -S10 -Frandom -08 -b8 -LS -F Param.txt The param.txt is as follows...

Log filled up disk

Thread by: TRACEYSQL, Jul 3, 2007, 1 replies, in forum: T-SQL Performance Tuning for Developers

Right now im trying to get up my cluster for SQL as one of the LOG Database grew out of control. When i finally get up system. To clear out the LOG...

Replication stopped

Thread by: TRACEYSQL, Mar 19, 2007, 6 replies, in forum: SQL Server Clustering

We have two servers Clustered together for SQL 2000 We have replication from Each of the servers Does anyone know what protocol its using for...

Display two integers

Thread by: TRACEYSQL, Mar 17, 2007, 3 replies, in forum: General Developer Questions

im trying to display ascii value of my data in a table Set @ASCII_CONCAT_DISPLAY = @ASCII_CONCAT_DISPLAY + @ASCII_CONCAT This line is taking the...

Move table to filegroup

Thread by: TRACEYSQL, Feb 21, 2007, 8 replies, in forum: SQL Server 2005 General DBA Questions

In 2000 i could do this just like the example here http://www.sqljunkies.com/HowTo/B9F7F302-964A-4825-9246-6143A8681900.scuk right click on table and...

Error with update

Thread by: TRACEYSQL, Jan 18, 2007, 1 replies, in forum: General Developer Questions

I have this procedure which i run from One server A which calls another serverB All works great and the results are printed out but...

Adding a login to sql

Thread by: TRACEYSQL, Jan 11, 2007, 3 replies, in forum: General DBA Questions

Im trying to write a stored procedure that will allow me to add a user to SQL through web page. I got this part done exec sp_addlogin @UserName,...

user logins

Thread by: TRACEYSQL, Jun 18, 2006, 4 replies, in forum: General DBA Questions

moving users from one database to another. i just did a restore and the logins are not there i do not want to bring over master as i only rebuilt one...

SQL install

Thread by: TRACEYSQL, Jun 6, 2006, 1 replies, in forum: General DBA Questions

Im reading this https://www.dpro.com/manuals/MSSQLInstallationGuide.pdf#search='SQL%202000%20installation%20guide' on page 6 Data Files I want the...

windows authentication SQL

Thread by: TRACEYSQL, May 23, 2006, 6 replies, in forum: General DBA Questions

Im new to this company and now getting involved in the SQL Security. A new person comes onboard and he the web person and wanted access to the...

ROWS of data gone up high

Thread by: TRACEYSQL, May 15, 2006, 1 replies, in forum: Performance Tuning for DBAs

sp_spaceused row in one table went from 800 rows to 313156 Format DBCC SHOWCONTIG scanning 'Z_ET_LK29' table... Table: 'Z_ET_LK29' (1600112841);...

user permissions

Thread by: TRACEYSQL, May 10, 2006, 1 replies, in forum: General DBA Questions

I have a dts job that i set up user and get the error message The current user is not the database or object owner of table 'dbo.ET_CHRG'. Cannot...

LOCKS

Thread by: TRACEYSQL, Apr 26, 2006, 2 replies, in forum: General DBA Questions

I have looked at the sp_who2 and got the results. ..and then do a DBCC INPUT BUFFER(spid_id) But i get calls saying SQL is locking me out....How do...

sp_spaceused on one line

Thread by: TRACEYSQL, Apr 25, 2006, 13 replies, in forum: General DBA Questions

Im trying to get all of this Is there a way to get the following: server, database, database size(mb),<br...