SSMS 2008 doesn't recognize variables starting with 2 @ signs
Tue, 15 Dec 2009 11:14:01 -0800
The intellisense feature in SSMS 2008 is great but alot of my old stored
procedure code uses local variables that start with 2 @ signs, e.g. @@index,
etc. This is valid syntax for the variables but SSMS 2008 highlights these as
errors. Is there any way to configure SSMS 2008 to recognize these? ...
|
How transfer objects and data from SQL 2000 tot 2008?
Mon, 14 Dec 2009 18:29:08 +0100
The 2008 SQL server can see the 2000 on a different machine.
- The import/export wizard no longer has 'Copy all objects and data' option.
If I select "all tables" constraints like primary key etc do not copy over.
- If I try a backup/restore Server 2008 complains that it is a backup from a
database "other th ...
|
SQL 2005 to 2008, then back to 2005
Mon, 14 Dec 2009 08:46:01 -0800
If I've got a SQL 2005 database that I want to import to SQL 2008, but never
upgrade it to a 2008 database, can it be unmounted and re-imported back to
SQL 2005?
--
-Andy Stevens
Jr. Web Developer
Adams Keegan
http:\\www.adamskeegan.com
Re-think HR. Think Adams Keegan. ...
|
BCP error "Cannot open database "XXXXXX" requested by the login"
Mon, 14 Dec 2009 01:53:01 -0800
Hello, I am having a problem relattin go BCP and SQLServer 2005, which is
reported as a bug to Microsoft, check link :
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351111.
I updated to Sql Server SP3 but the problem still occurs. I could easily
remove the -q option from the B ...
|
Default behaviour when opening .sql files
Tue, 8 Dec 2009 08:50:01 -0800
Hi All,
As a dba, I spend a lot of of time opening .sql files. I've just moved from
XP to windows 7.0 and am suffering with a small change in behaviour that is
quite irritating.
Previously, on my xp machine, I could open Management Studio using Run As
(my admin account), then select the server in Objec ...
|
Re: Fetching Data from 2 tables and send in text File using query
Tue, 08 Dec 2009 08:56:06 +0100
On Mon, 7 Dec 2009 22:50:27 -0800 (PST), chintu4uin@gmail.com wrote:
(snip)
Replied in comp.databases.ms-sqlserver.
Please don't post the same question to multiple newsgroups.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
|
Differences between SSMS Express & SSMS 2005 other editions
Sat, 5 Dec 2009 16:02:01 -0800
I'm using SSMS Express to feel my way around SQL Server 2005 Express as a
beginning admin. I'm using Microsoft Press's "SQL Server 2005
Administrator's Pocket Consultant" as a reference, and it doesn't match up
with my SSMS Express interface. For example, right-clicking on a table object
in Object View shou ...
|
|
|
SQL2005 Transaction Log Backup File Large after Full Backup
Thu, 3 Dec 2009 08:10:02 -0800
I have a database that is 400gb in size and is in full recovery mode. We
perform a full backup nightly and apply this backup to the reporting server.
Transaction log backups are performed hourly. I have noticed at times that
it appears that after the full backup the next hourly transaction log is
huge, in ...
|
SSMA could not retrieve the extension pack version number
Mon, 30 Nov 2009 12:05:01 -0800
When opening the SQL Server Migration Assistant for Oracle SQL Server
instance for conversion it gives me the following error: "SSMA could not
retrieve the extension pack SSMA4OracleSQLServerExtensions.dll version.
Reinstall the extension pack on the target database server."
It is odd that it is asked for ...
|
Index formula?
Tue, 24 Nov 2009 23:14:39 -0800 (PST)
Hi all,
Is there a formula into which values such as server specs, table and
row sizes, and index type can be plugged to compute the time for a SQL
Server 2005 index to be built?
Thanks,
Sean ...
|
