Experts:
I stopped the installation of SQL Standard 2005 because of this warning message prompted by setup CD disc before click next to install...
here's the warning message:
- Edition Ch...
Multipart identifier could not be bound error while migrating from SQL server 2000 to 2005
When executing the below mentioned query in SQL server 2005 the following error occurs
Multipar...
I have a backup of a database from a client site where full text indexing has been turned on. I want to restore it to a SQL installation that doesn't have full text indexing.
When I try to...
Hey all,
I've got a systems that is already in place that runs 3 HP blades (Dual Quad Core Xeon / 16GB memory), Windows 2003 R2 Enterprise, and SQL Server Standard 2005 SP2. All software i...
How can I backup my SQL server 2005 database (all tables and data) on my web host to an SQL script. I want to be able to run the script on SQLExpress on my local PC so I don't need logon infor...
I have an access project updating a sqlserver2005 table via adodb access 2005 and I am updating a datetime field in the server. regional settings are set to english-australia dd/mm/yyyy local...
EXEC msdb.dbo.sp_send_dbmail
@profile_name = '1',
@recipients = 'eoin.conway@meteorelectrical.com',
@subject = 'subject',
@body = '',
@query = @sql,
@execute_query_database = 'demo'
...
How can I sort on a datetime datatype
11/01/2002 09:35:19
11/01/2002 11:35:10
11/01/2002 07:35:09
order by does not give the correct results. I need to be able to sort on date then t...
You have heard this before but here goes:
I want to change Table 1 to Table 2
Table 1
id rank desc
1 2 hello
1 3 bye
1 4 home
2 1 hello
2 2 forget...
On occasion I need to overwrite/restore a database, I have a script to do that for me. Generally I would logon to the server console check SQL Ent Mgr to ensure no one is using the DB that I ...
We have a SQL Server 2k/2005 database. We need the ability to run a job that launches a basic query and then sends the output to a recipient's email address. What is the best way to do this?
Hi there,
I have been requested to run an automated query that runs once a week, for example on a Monday. The query needs to extract the data for the last 7 days. For example the date range...
I deleted a massive amount of data (6GB) from the database last night due to someone backing up massive tables in a production environment. I noticed this from the size of the backup increas...
Dumb Question. One i think i already know the answer to. I have a process that is kicked off via a web form on my web server. This process runs a stored procedure that executes a BCP comman...
I'm using the Copy Database wizard and I'm getting failure due to a
warning where a login is being copied but the login already exists. I
get the message:
The Execution method succeeded, ...
My SQL Server 2005 instance is set up to accept both SQL logon and Windows logon.
I am using the Windows Server administrator account, which has a login to the SQL server and a user in the da...
I have two sql boxes connected via a Point to Point fiber connection. I have no port restrictions etc between the two however they are on dif domains. I want to connect from on SQL box to anot...
Hi,
When I execute the following query...
DBCC shrinkdatabase(PCSystems, 30)
Its giving me an error...
DBCC SHRINKDATABASE: File ID 1 of database ID 11 was skipped because the file...
I would like to check if a row exists in a table and return true if it does.
Attached is a code that works correctly if executed in SQL.
If I call the SPROC from a method in .NET, I only ge...
I'm working on a stored procedure where I am putting together a substring. I've attached an image of the code in a screenshot.
The situation is that if 'see notes' is in the udAddInfo colu...
Hi
I have just setup SQL 2005 Express and I am atempting to connect my application. It prompts me to create a login and I have selected a comlex password with 12 characters mixed from UPPER...
Hello Experts,
I am trying to:
Update a table from a View FOR EXISTING RECORDS IN THE TABLE that have changed in the view from the last update (or Insert)
note. The table and View have...
After the sql query runs, when I copy and paste (or export to .csv) results in Excel - the header doesn't come with it. How do I get the header to copy over?
I need to remove a "-" from data in a table column. It's a chart number where they have three didgits followed by a dash and then two more digits. There are thousands of them so doing it one b...
Is there a better way to kill a runaway query being executed in the Management Studio than just exiting out of it?
