Viewing 15 posts - 691 through 705 (of 789 total)
and I recommend testing a restore of one or all of your user databases. The full process, from retrieving the backup off tape to doing the sql restore from...
June 25, 2003 at 9:24 pm
One solution is to use a function. Eg:
create table tblCSMainData (
AptDate varchar(10),
AptTime varchar(5),
...
June 25, 2003 at 9:11 pm
Can you give more details of what you're trying to check?
If just checking whether SQL Server has been installed, then MSSQLSERVER will be listed under Windows services.
If check which version...
June 25, 2003 at 8:37 pm
Regarding your point "it seems that we cannot restore the Master database at all", you can restore master when in single-user mode. However, that sort of restore needs to...
June 25, 2003 at 8:01 pm
Can you give an example? Include table creation script, insert statement and select statement.
June 25, 2003 at 5:29 pm
Can you give an example? Include table creation script, insert statement and select statement.
June 25, 2003 at 5:29 pm
The are articles about, regarding the use of Extended Properties of objects to document a schema. Of course, those extended properties need to be assigned each time the object...
June 25, 2003 at 5:23 pm
Andy,
One suggestion I might make is that the GAMES table might need to include 2 team IDs, because each unique game must be between 2 teams. Maybe TeamID1 and...
June 25, 2003 at 5:19 pm
Sorry, I can't help, but if solutions from this forum are thin, you can try the newsgroup microsoft.public.sharepoint.teamservices
In particular, one posting: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=22ec41fd.0209271102.3914f2c6%40posting.google.com
June 25, 2003 at 3:45 pm
You can try SQSH at http://www.sqsh.org/ but, not having a UNIX box, I've never used it nor had reason to try it. Good luck!
June 25, 2003 at 3:37 pm
MS have a KB article at http://support.microsoft.com/default.aspx?scid=kb;en-us;q309422
Also, stealing a quote from Neil Pike....
quote:
> Is it a good or...
June 25, 2003 at 3:25 pm
For the EXISTS, a different plan is generated for the first query, but IO is much the same. For the other 2 queries, IO is identical.
June 25, 2003 at 3:13 pm
The following works for me:
select 'job_ID: ' + cast(job_ID as varchar(100)) from sysjobs
Also the following works:
declare @job_id uniqueidentifier
select top 1 @job_id = job_id from sysjobs
print 'job_ID: ' + cast(@job_ID as...
June 24, 2003 at 4:10 pm
Your DBA dropped PUBS on your DEV box? Bit over-zealous isn't he/she? I can understand and agree in production, but pubs and northwind can be very handy in...
June 24, 2003 at 4:04 pm
Maybe there's nothing to be logged. No jobs being killed, and possibly no backups happening because SQL Agent not started?
Could you have cycled SQL Server and forgot to restart...
June 24, 2003 at 3:53 pm
Viewing 15 posts - 691 through 705 (of 789 total)