2003-05-13
career
RE: grant dba role
Hi, well in EM goto Security -> Logins. Select your user -> right-click -> properties. Select 'Database Access' Tab. Check 'Permit' and 'db_owner' for each DB. It's a stupid activity , if someone knows a smarter way in EM, please let me know Cheers, Frank
2003-05-12
1 reads
RE: Handling The Text Data Type
In theory it should speed up the query because for those text fields that have few enough characters to fit in the row SQL Server won't have to do a look up for those characters using a pointer. However, I think it might not always be beneficial (although I have not tested this yet) because […]
2003-05-09
1 reads
RE: Cannot Stop SQL Server Agent
Those servers may be in different domain than others that you have permission to start/stop services. You can remote manage those serevers to start/stop services but you need to be local administrator in those machines.
2003-05-09
1 reads
RE: More than 2 Databases Synchronization
Merge replication probably the easiest way. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-09
RE: increasing number of bytes per row
If after reaching that point you BCP out/in, then try to modify, do you get the error then? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-09
1 reads
RE: increasing number of bytes per row
This is interesting, looks like there is a hidden piece to allocations.
2003-05-09
1 reads
RE: Convert ASCII
I am pretty srue there is a proper conversion however I cannot seem to find it right off. But here is a way that will work DECLARE @s as VARCHAR(2) SET @s = '4F' EXEC('SELECT ASCII(CAST(0x' + @s + ' as varbinary(1)))')
2003-05-09
RE: sql server agent alerts
When you say you see these, where do you mean you see this? Each is a demonstrative Alert to provide examples of Serverity based alerts but if your server is generating them you may have an issue. I changed all of mine from the Demo name to Fatal Error: Sev. 25 Errors and left enabled. […]
2003-05-09
RE: xp_sendmail rearranges Print and Select
Thanks. That makes sense. How do I go about managing the flow control then?
2003-05-08
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers