Is there an application that works as DBCC wizard?
DBCC (DB Consistency Check) commands are powerful tools but they don,t have a graphical user interface. now Is there a application that works like DBCC wizard? ...
sql-server
Point on Circle (Longitude/Latitude) in .NET/SQL
Hello ;) I've got the following problem: I have a table with long/lat values and another table with a project-id and long/lat/radius (circle). Now I need to find out which project matches the long/lat values from the first table. Is there an easy way to do that? I'm using VB.net and a SQL Server. Thank you very much for your help. ...
SELECT SQL table retrieved by an IF statement
Hella all, What I want to do is something like that, I will have an SQL table depending on my parameter, DECLARE @find varchar(30) SET @find = 'no' SELECT * FROM ( if @find = 'yes' ( SELECT * FROM myTable WHERE ID= '5882' ) ELSE ( SELECT * FROM myTable WHERE OLD_ID= '5882' ) ) X This is ...
Multiple commands on one line in SQL Server 2005
I would like to execute multiple statements on one line in SQL Server 2005. How do I do the following on a single line: use master go sp_spaceused mytable When I try use master; go; sp_spaceused mytable I get Incorrect syntax near 'go'. When I try use master go sp_spaceused mytable I get Incorrect syntax near 'go'. ...
Problem combining result of two different queries into one
I have two tables (TableA and TableB). create table TableA (A int null) create table TableB (B int null) insert into TableA (A) values (1) insert into TableB (B) values (2) I cant join them together but still I would like to show the result from them as one row. Now I can make select like this: select (select A from tableA) as...
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing - SQL server 2005
I am getting the error from the application as following with SQL server 2005 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0" How can i find the stage where this error raised? how can i found the missing transaction or the stored...
renaming or creating the stored proc will cause server hang up
I have an already existing stored procedure. But when I am trying to create the stored procedure with a new name it hangs up the server. But If I execute the same with its usuall name it works fine. Any idea whats going wrong. Why the newly created one is taking too much time Script is fine. As with original one it works perfectly but A...
Read/extract data from sql server backup file without restoring
Hi All, Is there any way to read/extract data from sql server backup file without restoring it? Thanks. ...
How can I create valid connection string by using shared memory protocol to connect a named instance of sql server?
How can I create a valid connection string by using shared memory protocol to connect a named instance of sql server while the sql server browser is disabled? ...
How can I get a list of element names from an XML value in SQL Server
I have a table with an XML column in SQL Server 2k8. The following SQL retrieves some XML: SELECT TOP 1 my_xml_column FROM my_table Let's say it returns me the following XML <a> <b /> <c> <d /> <d /> <d /> </c> </a> What I would like to get is /a /a/b /a/c /a/c/d /a/e In other words, how can I get SQL Server to...
What does this sentence mean: Clustered indexes are stored physically on the table?
How are clustered indexes stored on a hard disk? What is the logical order? How do non-clustered indexes work? ...
How to convert snapshot files to any other format?
Hi All, Is there any way to convert the Sql Server 'Snapshot' files (*.ss files) to some other format...like 'xml','xls' or 'txt'...etc. Thanks. ...
check for existence before insertion in stored procedure
In my stored procedure, I would like to check to make sure what I am trying to insert doesn't already exist in the table. I have tried the code below, but it seems to be giving me false positives (aka comes out to true even when it's not in the table). Is there a better way? if not exists (select myID from tableName where myID = @myID a...
Changing SQL Server settings programmatically
Hello friends, I request you to read my question carefully. You might know when you install VS2005/2008 with SQL Server Express edition, the SQL Server operates in Windows authentication mode by default. You can use the SQL Server Management Studio to change the mode to Mixed mode (Windows and SQL Server Authentication mode). Similar...
SQL Server Query Returning Multiple Rows
I am currently working on a SSIS package that is extracting a table from one database to another. The tables in both of the databases use the same column as the primary key. My select statement to extract the data is a simple select statement. When I ran the package I was receiving a error that there where duplicate primary key values...
How to choose the clustered index in SQL Server?
Usually the clustered index is created in SQL Server Management Studio by setting the primary key, however my recent question about PK <-> clustered index (http://stackoverflow.com/questions/2262998/meaning-of-primary-key-to-microsoft-sql-server-2008) has shown that it is not necessary to set PK and clustered index to be equal. So how s...
Fetch CSV value from XML data type in SQL Server 2008
I want to store the CSV to XML data type in the SQL Server table and has to return from that. What is the best way of doing this. I am facing some performance issues for 50,000 comma separated values. Note: I am using SQL Server 2008 ...
Can you add identity to existing column in sql server 2008?
In all my searching I see that you essentially have to copy the existing table to a new table to chance to identity column for pre-2008, does this apply to 2008 also? thanks. most concise solution I have found so far: CREATE TABLE Test ( id int identity(1,1), somecolumn varchar(10) ); INSERT INTO Test VALUES ('Hello'); ...
SQL Server Management Studio 2008 - Standard Reports - Schema Changes History - How is the Date Determined?
SSMS 2008 comes with a great set of standard reports, including one named Schema Changes History. When I run this report, I see all schema changes made since a certain date. My question is this. How is the date determined? For example, on one database for a particular server, the changes are as of 2/14/2010 1:35:15 pm. But on another dat...
Add non-nullable columns to an existing table in sql server?
I already have a table which consists of data. I need to alter table to add two new columns which are not null. How can i do that without loosing any existing data? NOTE: The new columns are not null fields. ...