Viewing 15 posts - 691 through 705 (of 790 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...
Cheers,
- Mark
June 25, 2003 at 9:24 pm
One solution is to use a function. Eg:
create table tblCSMainData (
AptDate varchar(10),
AptTime varchar(5),
...
Cheers,
- Mark
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...
Cheers,
- Mark
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...
Cheers,
- Mark
June 25, 2003 at 8:01 pm
Can you give an example? Include table creation script, insert statement and select statement.
Cheers,
- Mark
June 25, 2003 at 5:29 pm
Can you give an example? Include table creation script, insert statement and select statement.
Cheers,
- Mark
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...
Cheers,
- Mark
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...
Cheers,
- Mark
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
Cheers,
- Mark
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!
Cheers,
- Mark
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 bad thing...
Cheers,
- Mark
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.
Cheers,
- Mark
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...
Cheers,
- Mark
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...
Cheers,
- Mark
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...
Cheers,
- Mark
June 24, 2003 at 3:53 pm
Viewing 15 posts - 691 through 705 (of 790 total)