Viewing 15 posts - 226 through 240 (of 2,897 total)
If you run the code in a SQL Window, not as a stored procedure, then when you get an error message, double-click the error and it jumps to the area...
September 9, 2021 at 5:11 pm
Why is your substring length 48 ?
select *,REPLACE(SUBSTRING(INFO, 32, 48), CHAR(13), '') as 'Cast as BIGINT ?'
FROM (
...
September 9, 2021 at 2:23 pm
Backup history files might show you what account (user_name) ran the backup if you can find an entry for that database, date & time.
Ant's "Ask Around" suggestion will probably give...
September 7, 2021 at 12:59 pm
Consider the possible negative performance impact of "Shrink" and have a plan to rebuild indexes.
https://www.sqlservercentral.com/forums/topic/slow-performance-after-database-shrink
September 1, 2021 at 1:40 pm
If there is a large amount of free space, I would shrink it incrementally in smaller chunks.
Yes, I was just about to say the same thing.
Or just leave the...
September 1, 2021 at 1:35 pm
BCP aka Bulk Import/Export is 1 option
September 1, 2021 at 12:58 pm
other than those two sql query execution , I did not do anything else.
The login just gives access to a connection.
After you create the login you have to give...
August 31, 2021 at 7:31 pm
Nothing useful can be determined by just posting a query.
Read the 2 "How to Post" links at the bottom of Jeff Moden's post.
August 31, 2021 at 4:40 pm
You may need to hit "Refresh" for your new login to appear.That already showing there !
Error comes even after that.
Have you given the user any type...
August 31, 2021 at 12:43 pm
Scroll Down to "Local Temporary Table"
I have some created 2 months ago. The above article says
"You get housekeeping with Local Temporary tables; they are automatically dropped when they go...
August 30, 2021 at 5:27 pm
Are you referring to Temporary Tables in TEMPDB ?
I see I have quite a few also, with names like
#BF1C9DD8
#AC5C13E1
#AC7698F6
#AC11FB1E
#AC444A0A
#AAA61A5B
#AAC09F70
Some of mine have a few records , some have 0, according...
August 30, 2021 at 5:22 pm
Go To
SERVER ---> Security ---> Logins
You may need to hit "Refresh" for your new login to appear.
August 30, 2021 at 4:58 pm
Spectra, you can use the GUI to set permissions, and use the "SCRIPT to Query window" option and SQL will put the commands in a new query screen so you...
August 30, 2021 at 4:08 pm
Setting a default database is not permissions. It just tells SQL which database to set the initial connection for that user.
I already did this
ALTER LOGIN [TheLogin] WITH DEFAULT_DATABASE =...
August 30, 2021 at 3:45 pm
Isn't the table variable deleted when the process completes ?
August 30, 2021 at 12:42 pm
Viewing 15 posts - 226 through 240 (of 2,897 total)