Viewing 15 posts - 16,936 through 16,950 (of 59,067 total)
Just to be clear here...
You can't disable the actual Windows Login from SQL Server (well, you can but only if the server has Domain Admin privs and you really know...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 8:31 pm
SQL Galaxy (8/24/2016)
The following include two different query in different database for fetching data. but...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 7:47 pm
p.s. It's also a huge waste of disk space to audit INSERTs. Only audit UPDATES and DELETEs. INSERTs will always be in the original table until they're...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 7:25 pm
You need to write a trigger to do this.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 7:24 pm
Yes but why are you using NVARCHAR to store "digits"? Also, you've not stated the full datatype for the column. NVARCHAR(???) ? And, what do you want...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 7:22 pm
komal145 (8/24/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 7:12 pm
learningsqlkid (8/24/2016)
Now someone in my team mentioned that this can be achieved easily with windows workflow foundation which provides the same capability in much more flexible way
That "someone" made...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 7:08 pm
The FLOAT datatype isn't based on the DECIMAL numbering system although the result is displayed as such. FLOAT is based on BINARY representations of DECIMAL numbers and, when you...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 8:48 am
durga.palepu (8/24/2016)
I have verified this and it works fine for me, refer to the attachment.
Just post code in the future, please. No one can execute a JPG.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 8:19 am
BTW... if the table isn't critical to a DR restore, you might want to simply move it to another database and add a synonym for it. That would allow...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 8:12 am
pdanes (8/24/2016)
BLOB_EATER (8/24/2016)
Your MDF is 500MB with 8 years growth? I'm not so sure you need to go down this...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 8:07 am
I've done the "Create a table and use INSERT/EXEC" thing in the past. Works fine but it's an initial pain. There are a whole lot of things in...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2016 at 7:36 am
Grant Fritchey (8/16/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2016 at 8:03 pm
michaelfeldman (8/23/2016)
error:
Error: 0x0 at Foreach Loop Container: The object in...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2016 at 7:57 pm
Rowan-283474 (8/23/2016)
Sergiy (8/23/2016)
Rowan-283474 (8/23/2016)
Rowan-283474 (8/23/2016)
Sergiy (8/23/2016)
Sergiy (8/22/2016)
Do you really have the case when the source table does not have any kind of time stamp or an auto-incremental ID?
Can you answer...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2016 at 7:52 pm
Viewing 15 posts - 16,936 through 16,950 (of 59,067 total)