Can you restore a backup from newer version of SQL Server to older
version, if in compatibility mode?
Thu, 25 Feb 2010 08:35:11 -0800 (PST)
Can you restore a backup from newer version of SQL Server to older
version if in compatbility mode?
i.e. there is a db on SQL2005 running in SQL2000 compatibility mode.
Can you restore a backup of this db onto SQL 2000?
I'm pretty sure the answer is no - I just want an authoratitive
answer.
Cheers,
Ja ...
|
perfmon counter
Thu, 25 Feb 2010 07:23:03 -0800
Is there a perfmon counter that reports task CPU usage similar to
sys.dm_os_tasks, or sys.dm_exec_requests?
I don't think so and in looking, I don't see any. But I thought I would
check.
...
|
SSIS Help
Wed, 24 Feb 2010 19:20:07 -0800 (PST)
I have an SSIS package that runs multiple times a day. The package
pulls all data from an AS400 table (F55EZIVD) and imports it to a SQL
table (chatt_INVOICE_ITEM_TEMP).
Now I would like to write back to the AS400 table and update a field
if the record has already pulled into our SQL DB.
Can this be done ...
|
Adding a column in a certain position
Wed, 24 Feb 2010 16:41:15 -0800 (PST)
I have an ALTER table script that adds a new column. Problem is, it
adds it to the bottom of the list of columns. Is there a way to insert
it into a particular position, without having to read all the data
into a different table, recreated the table, and get all the data back
in? ...
|
Can't save existing .trc file to table Profiler 2008
Wed, 24 Feb 2010 12:03:07 -0800 (PST)
Hello, I'm new to SQL Profiler. I've created a .trc file and saved it
to disk. I can open the .trc file but I want to now save this
existing file to a table. When I go under Save As all the options are
grayed out. I have another .trc file and when I open that file and
select Save As all the options are avail ...
|
Linq to SQL... why not use it?
Wed, 24 Feb 2010 09:23:19 -0800
Friends,
I've always just used SQL of my own creation, (often with programmatic
fluff), that is ultiamtely sent to SQL Server. Now with Linq, the "text
within code" model could be changing. A respected member here stated "do
not use LINQ to SQL, unless you are strictly doing stored procedure access.
And ...
|
Quering the reference tree
Wed, 24 Feb 2010 03:43:57 -0800 (PST)
Hello,
I am wondering if there is a nice way how to make a SELECT that would
return full history of a tree-structure.
Here's my table field list:
1) ID (int) - unique identifier
2) _parentID (int) - reference to parent entry in this same table
3+) [number of other tree node fields]
Let's say, the data i ...
|
|
|
Select previous 52 weeks for every week in calender table
Tue, 23 Feb 2010 16:27:26 GMT
Hello,
I'm trying to create an SQL statement that will retrieve the previous 52
weeks for every week defined in my calender weeks table.
Let's say the calender_weeks table contains 1 field called week_no - numeric
(6,0).
The following SQL statement works fine for a given week. I would like to know
if it' ...
|
running dbcc shrinkdb prior to restore database
Tue, 23 Feb 2010 07:57:01 -0800
hi,
i do have a 7.2 gb database. running dbcc shrinkdb it goes down to ~1.5 gb.
unfortunately i do have only 5 gb left on file system (yes, this is possible
in these days :-S) and have to restore the database on a weekly basis.
how can i run dbcc shrinkdb on the same sql server(!) - or something
similiar ...
|
error code 0xc0000000 to spawn a thread to process a new login or
Tue, 23 Feb 2010 06:32:04 -0800
I have a SQL Server 2005 database server that using a large amount of
memory which created the error listed below.
Error Message:
SQL Server failed with error code 0xc0000000 to spawn a thread to process a
new login or connection. Check the SQL Server error log and the Windows event
logs for information ...
|
