| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi.
How deleted records can be recoverd ?
Regards,
Muhammad Bilal
Muhammad Bilal
|
08-22-2009 02:15 AM
Tibor Karaszi  | 1 | 28 |
| | | Hi.
How can be join applied on two tables in different databases.
Regrds,
Muhammad Bilal
Muhammad Bilal
|
08-22-2009 02:14 AM
Tibor Karaszi | 1 | 29 |
| | | Hello
If I have a Masterserver (MSX) and a Targetserver (TSX) can I perform
"Log Shipping" whereas I ship my transaction logs from my...
JB
|
08-21-2009 08:49 PM
Linchi Shea | 1 | 28 |
| | | I have a SS2000 instance which needs to start a job on a SS2008 instance. Is
there a sane way to do this?
Thanks,
Mike
Snake
|
08-21-2009 03:05 PM
Aaron Bertrand | 2 | 24 |
| | | Hi,
I have created a database in SQL Server 2008, with compatibility level
of SQL Server 2000. Now when I detach the DB and try to attach it to
and...
sheperson@googlemail.com
|
08-21-2009 02:05 PM
Aaron Bertrand | 7 | 27 |
| | | Our company recently purchased Goldmine to replace our current CRM software
and it came with SQL 2008 Workgoup Edition. I cannot execute a...
Willis
|
08-21-2009 01:59 PM
Russell Fields | 3 | 27 |
| | | Installed the SP3 for SQL server 2005 in a cluster environment. The
installation was done on active node. The log file shows successful
installation....
ittech
|
08-21-2009 11:37 AM
TheSQLGuru | 4 | 31 |
| | | I'm still fairly new to managing a SQL server , but I've started using some
script I found on the Microsoft, SLQMag and SQLServer Central web sites...
Chris
|
08-21-2009 11:01 AM
Linchi Shea | 1 | 28 |
| | | Hi there all,
This is for SQL 2000 on SP4
The eventlog showed messages for application hangup and the sql errorlog
showed timeouts errors followd by...
Humayun
|
08-21-2009 07:45 AM
Linchi Shea | 1 | 35 |
| | | SQL Server 2000 SP4. Last night, I tried to do a restore using Enterprise
Manager. When I right-click the db and choose Restore Database, all I get...
Ron Hinds
|
08-20-2009 07:33 PM
Ron Hinds | 7 | 33 |
| | | Hi,
Our production databases hang up yesterday somehow, we even couldn't stop
SQL-Server service (no response). we had to re-boot the server.
Please...
yong
|
08-20-2009 07:05 PM
TheSQLGuru | 1 | 85 |
| | | --
JB
JB
|
08-20-2009 05:11 PM
Andrew J. Kelly | 1 | 38 |
| | | Thanks for your reply.
I'm sure I'm not unique in this, however, it is from observing traces
and execution plans under various scenarios. BizTalk...
Crippster
|
08-20-2009 05:10 PM
Andrew J. Kelly | 1 | 22 |
| | | SQL novice. Have different versions of SQL backups. Is it possible to
restore backup of SQL 2000 or SQL 2005 to SQL 2008. From 32bit to 64bit?
John
|
08-20-2009 02:28 PM
John | 4 | 35 |
| | | Our Database backup jobs run at 2.am every night. My questin is when Daylight
saving occurs in Spring does does the job skip all jobs that run...
opokad06
|
08-20-2009 01:25 PM
opokad06 | 3 | 28 |
| | | I have a SQL Server 2005 job that shows the duration the last time it ran as
1.09:03:12. I am guessing this means that the job ran for 1 day, 9...
Demian
|
08-20-2009 11:44 AM
Royce | 3 | 64 |
| | | I have SQL2008 installed on and SBS 2008 server. I am using Backup Exec 12.5
with the SQL agent. When I try to select the SQL databases from the...
Jarrod
|
08-20-2009 10:30 AM
Jarrod | 0 | 24 |
| | | Hi,
Thanks to Lucas and others the
exec sp_helptext 'myobjectname'
does return the content.
Upon testing against 10 to 15 objects
about 5-10% of...
mtnw
|
08-20-2009 09:16 AM
Linchi Shea | 2 | 29 |
| | | hi All
I having issue with one store proc, when I execute store proc it provide
below error msg
Updated or inserted row is bigger than maximum size...
gbkhor
|
08-20-2009 09:10 AM
gbkhor | 4 | 25 |
| | | Hello
Using the Full Recovery Model I have a database backup and 3 transaction
logs that I backed up.
RESTORE HEADERONLY shows that there are only...
JB
|
08-20-2009 08:40 AM
Lucas Kartawidjaja | 3 | 28 |
| | | Hi,
irregularly I get the following messages from SQL 2005:
SQL Server Management Studio & ASP.NET application gives me:
TCP Provider, error: 0 -...
Petr Langer
|
08-20-2009 06:17 AM
Erland Sommarskog | 1 | 28 |
| | | I have Oracle Database in version 8i, sharepoint server 2007 with WSS 3.0 and
Framework .Net 3.0
I have 3 tables in oracle 8i that I 'll want to...
Emilie FAIVRE
|
08-20-2009 02:23 AM
Emilie FAIVRE | 0 | 34 |
| | | Hi,
The sysobjects table contains the list of stored procedures and functions,
etc.
Is there a way programmatically to fetch the source text for...
mtnw
|
08-19-2009 04:56 PM
mtnw | 3 | 36 |
| | | I'm trying to set up SQL Alerts to use an AOL email account via "Database
Mail" in SQL Server 2005.
AOL's server responds with this failure...
GerhardL
|
08-19-2009 04:55 PM
Aaron Bertrand [SQL Server MVP] | 1 | 18 |
| | | I have an architecture where my principal and mirror SQL on WLBS , and need
to have synchronous mirroring with automatic failover , apps connects...
sacgar
|
08-19-2009 10:45 AM
Linchi Shea | 3 | 64 |
| | | Link for version comparison:
SQL 2005: http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
SQL 2008:...
Lucas Kartawidjaja
|
08-19-2009 08:28 AM
Lucas Kartawidjaja | 0 | 24 |
| | | I have perused many newsgroups and have yet to find the answer or solution to
this problem. I have a login lets call it abc in my ad on my dc. ...
seeker
|
08-19-2009 08:23 AM
Lucas Kartawidjaja | 5 | 30 |
| | | not that i have done this (yet) but thought it maybe prudent to explore ...
now and again i need to update a row
update table set id = # where...
Scott
|
08-19-2009 07:18 AM
Dan Guzman | 2 | 39 |
| | | I have a user who wants to create a 'job' in SQL Server...
This job will run a SQL query and generate an email nightly
I want to give the user the...
Blake
|
08-19-2009 06:57 AM
Blake | 4 | 50 |
| | | Greg:
Check the Package Protection Level property of the SSIS package (under the
Security section). If you are in fact using one of the 4 choices...
Todd C
|
08-19-2009 06:46 AM
Todd C | 1 | 26 |
| | | Hello
Can anybody tell me when the SQL 2008 MCITP BI Developer MOC courses
(equivalent to SQL 2005 courses 2794, 2795, 2796 and 2797) are going...
Ian Allchin
|
08-19-2009 03:59 AM
Ian Allchin | 0 | 27 |
| | | I spent one hour looking for a way to extract a string in the format
yyyy-mm-dd from a date time object.
At the end I give up and I defined a custom...
M. S.
|
08-19-2009 03:36 AM
Eric Isaacs | 3 | 27 |
| | | After installing SQL Server Management Studio 2008 I get the following
error alert whenever I right click on a table to get the table menu:
EXECUTE...
sikander
|
08-19-2009 01:38 AM
sikander | 3 | 59 |
| | | Hi,
Our email server has been changed and now my subscription reports from our
SQL 2000 report server don't send. I can't find where to change the...
Gonzo
|
08-18-2009 11:35 PM
TheSQLGuru | 1 | 34 |
| | | hello
I created a backup device for my database and transaction log.
Yesterday I performed a database backup and a transaction log backup to
those...
JB
|
08-18-2009 09:00 PM
Jeffrey Williams | 1 | 41 |
| | | I have some questions if anyone is. Let me know if you are.
Bob Badour
|
08-18-2009 08:32 AM
Andrew J. Kelly | 1 | 28 |
| | | Hi,
I am trying to install Aventure Works database on the SQL SErver
2008 Express edition. I got the AdventureWorksDB.msi off of the web
saved it to...
Learner
|
08-18-2009 07:57 AM
Learner | 4 | 42 |
| | | I recently had an issue with being able to log into my Windows XPS Vista
Ultimate notebook. I contacted Dell Support who helped me rectify...
Tom R
|
08-18-2009 06:51 AM
Tibor Karaszi | 8 | 38 |
| | | First off, I know to not shrink datafiles on a whim, but I do need to
reclaim some space in this on Database that is causing me headaches.
The...
David Hay
|
08-18-2009 06:39 AM
David Hay | 5 | 30 |
| | | Hi Folks,
I have a table with two columns which are ScheduleDate (datetime),
Memory(decimal). Every two minutes a row will be inserted in this...
Jayakrishnan
|
08-18-2009 03:57 AM
Jayakrishnan | 1 | 60 |
| | | I heard we can set up the log shipping from sql 2008 to sql 2005 with some
work ground , can some give some insight?
sacgar
|
08-17-2009 09:30 PM
Lucas Kartawidjaja | 2 | 27 |
| | | Hi All,
i posted an issue last week - still having a problem with writing a
sql query.
I'm using Windows 2000, SQL Server 2000 and would like it if...
SQL Server
|
08-17-2009 07:05 PM
SQL Server | 8 | 34 |
| | | Hello:
I have looked all over newsgroups for this issue and none of the suggestions
are working.
I am trying to install SQL 2005 Standard SP3 and...
childofthe1980s
|
08-17-2009 05:00 PM
Geoff Schaller | 3 | 44 |
| | | We recently purchased Microsoft SQL Server 2008 workgroup edition and would
like to downgrade to SQL Server 2005 workgroup edition. It appeared that...
Ryan
|
08-17-2009 04:51 PM
Erland Sommarskog | 2 | 29 |
| | | Hello
I am going to shrink a transaction log and possibly shink the database
as well.
1-Do I have to wait until all users are logged off to shrink...
JB
|
08-17-2009 04:49 PM
Erland Sommarskog | 2 | 52 |
| | | Hi All,
The drive tempdb resides on is formatted and removed permanently from a test
server. What should be the quickest way to recover SQL Server...
Ada
|
08-17-2009 04:31 PM
Ada | 6 | 22 |
| | | I have 2 databases A and B
Both these databases have a Vendor table. On Database A I want to upgrade
the columns in the Vendor Table based on the...
Sammy
|
08-17-2009 03:43 PM
Plamen Ratchev | 1 | 22 |
| | | We are planning to initially virtualize some of our SQL Server environments.
Are there any recommendations from Microsoft in the form of some white...
MZeeshan
|
08-17-2009 03:03 PM
Andrew J. Kelly | 1 | 16 |
| | | Where can I find the list of disabled featured in the SQL Server 2005 & 2008
Express editions? For example, I'm pretty sure SSIS is disabled in...
Jay
|
08-17-2009 01:18 PM
Andrew J. Kelly | 1 | 27 |
| | | Hi. I just upgraded a SQL 2005 Ent Edition to SQL 2008 Ent Edition. I used
the "Upgrade from..." option of the setup installation menu. The upgrade...
FinFlorida
|
08-17-2009 10:07 AM
FinFlorida | 2 | 26 |
