Trying to restore a backup copy of database but I am getting this error when I selected backup location from file. Any idea what this means?...
Hi All, I have written several stored procedures but rarely used function calls within these stored procedures. Even if I used, they were already...
Hi all, I am just curious what will be the recommended way to truncate table for huge number of datas with indices on it. I was asked to recommend...
Hi,<br /> Probably this is a dumb question and should've tried myself before posting here. [<img src='/community/emoticons/emotion-1.gif' alt=':)'...
Hi All, I have one table which has CustomerID, ApplicationID and DateModified. Each of these CustomerID has more than 1 records based on different...
Hi, I need help to concate some names. For example I have a input parameter @name = "Associate of Arts in Economics" and need to add this prefix...
Hi, Is there a way around to add column in existing table with NOT NULL? I am having a hard time adding column which references to other column as...
Hi Everyone, I have a script that has insert/update and also select. Can I put these in one transaction with GO for each dml command. Don't worry...
Probably, this might be a stupid question but can't figure this out why it is giving me: Msg 156, Level 15, State 1, Line 3 Incorrect syntax near...
Hi All, I have a requirement which need to order by in certain way. For example, i have a list of columns which selects from joining multiple...
What is this cursor trying to do? Isn't this a simple select and insert? Can I do this instead of cursor? Please help me with this. INSERT...
In the database, the StatisticValue is stored as numeric(18,4) and the flag is 1. I want to retrieve this data with case like this: select...
Hi, I would like to know what is the benefit of creating Synonym (Schema) for stored precedure in 2005? Dan
Hi, I tried sp_rename to rename the stored procedure in the database and it was renamed to the new name. But, when I scripted out or used...
Hi All, I am trying to find all the table names that are referencing to the stored procedure in the database. How can I get the list of table names...
Hi all, I need to prepare an xml contract for the application so that the engineers can work on their design. I am very poor in xml and didn't do...
Hi, How do I reset the identity value for a table that was truncated? For example, when I insert the records into a table and it generates the...
Hi, Does anyone know how to resolve this issue? We are using SQL Server 2000 Standard Edition and all the xml procs were working fine until we...
Hi Everyone, What is this error mean? I have SP that only selects, updates and deletes in one table(ContractCreditCard). Msg 4421, Level 16,...
Hi all, How can we find the dependency of a tables in a database? Is SP_DEPENDS TableName tells everything about the dependencies of that table or...
Separate names with a comma.
