SQL Server Tools

I have webspace running on a machine with IP address 82.165.206.115 through 1and1.com.  Then I have an internal server running on my network which is running SQL Server 2000.  I have yet to be able to ...

Hi,     I want to create temporary table, say "a" which has  a column say "col1" which i wnt to be an identity for which I need to provide a seed value.     I tried the following ...

Hi All, How can I work with jobs when agent is stopped? This could be done in SQL 2000 Enterprise manager but does not appear to be available in Management studio. I don't want to start the Agent as this will run the jobs. ...

I'm using Management Studio's Tasks->Import data tool to try to import data from a MS Access database .mdb file.  But, I keep getting the "the workgroup information file is missing or opened exclusively by another user" error ...

How do I determine what indexes are being used using profiler? What events do I capture? I see IndexID as a data column.. I assume I need this to query sysindexes... tia, chris ...

Hi I know that the Query Analyzer is merged with an tool in 2005. So which edition of Sql Server 2005 I need to install to have Query Analyzer on my machine? Thanks Raj ...

Hi,     Is there any way to get the error message within a stored procedure. I have to store the SQL Server error message in a table.     TIA Thanks P ...

I have a CRM 3.0 application running on a Windows server 2003 R2 and SQL 2005. I need to move the database and log file to a different drive from the current location. It is currently on C: which is the system partion. I need ...

Hi all, I work for Red Gate Software and we are doing some preliminary research into a SQL Server source control solution. We would like for this tool to solve as many real-world problems as possible, which is why it's ...

Is it possible to manually insert some data into image column in MSSQL Management Studio? I have defined a table that contains image column for inserting some binary data. I don't have the logic for inserting that data into ...

Hi,     Wanted to know what this option means in SQL Profiler, "Server processes SQL server trace data", read that SQL Server will not miss the events but the SQL Server will be loaded, but wanted to know how this option can be set ...

Hi! I have some problems with ms sql server database connection. When I wrote the following function (in VB): sub Remplir_Theme() Dim connectionString As String = "Data Source=.\SQLExpress; AttachDbFileName=|DataDirectory|\BasedeDonnees_babySQL.mdf ;Integrated Security=true; User Instance=true" Dim sqlCon As new System.Data.SqlClient.SQLConnection ...

Hi, I am running SQL Server Management Studio on a dell inspiron 9300 with an ATI Mobility Radeon x300 graphics adapter. So far so good, but there is one particular function in the GUI that don't work as expected with the ...