Thanx for your quick response. OK. The maintenance plan is for the master, model & msdb. The master & msdb are set to Simple and the model set to Full Recovery mode. I checked the permissions tab on all: The user/roles listed on the permissions tab are public, guest, printuser, and 2 other user groups. […]
2003-08-26
2 reads
Somedays they pay me what I'm worth. Somedays they pay more than I'm worth. Somedays they just don't have that kind of money in the budget. Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance. Patrick
2003-08-25
Andy, Thank you for the help. So if I understand you correctly the identity column must just be manually recreated on the subscription database and it should work fine? What about all the table relationships, is that taken over as well when creating the replication DB? Regards Raino Botha
2003-08-21
1 reads
I usually try something like this "kill & set" in an attempt to get the single_user option in before the other user/app does: use master declare @kill varchar (8000) select @kill = ISNULL(@kill , '') + ' kill ' + cast(spid as varchar) from sysprocesses where dbid = db_id('pubs') print @kill exec (@kill) exec sp_dboption […]
2003-08-13
How about the SQL Server command CONVERT: SELECT CONVERT(VARCHAR(23), GETDATE(), 121) That will return the date and time in the format you want. yyyy-mm-dd hh:mi:ss.mmm -SQLBill
2003-08-04
2 reads
You're not trying to install on Win 2003 Beta, or the Web Edition are you? There's issues/restrictions with them. Cheers, - Mark
2003-08-03
sorry, bit too quick there, it's s self join. This effectively is two copies of the base table so you can do something like "AND t1.DateField < t2.DateField"
2003-07-17
How about: SELECT <rows>, COALESCE(<nullcolumn>, 'ZZZZ') AS <nullcolumn> FROM <table> ORDER BY <nullcolumn> ASC
2003-07-14
After reading this topic I ran some tests that shows me something different about LIO and PIO's, as shown by 'set statistics IO on'.. If I do a scan on a 40000 block table on a freshly started DB (so nothing cached (in SQL(!)), 'stats' tell me it's doing 1 scan, 40000 logical reads, 0 […]
2003-07-11
2 reads
Hi shas3, Thanks for ur prompt reply.It was spot on. The db giving problems had 251 entries in sysindexes while other one had 7 for that table !! In my case i dropped and recreated the table. But in case that isnt possible i was wondering what could be the easiest way to put the […]
2003-07-10
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers