Posts
Sort by recent activity
SQL Prompt Not Recognizing Alias
I have this query, already written out:
Select
Left(S.FirstName, 20), Left(S.LastName, 20),
Left(Replace(P.SS, '-', ''), 9), Left(S.Address, 35), Left(S.Address2, 35), Left(S.City, 35),
Left(S.Stat...
Another Failed List
I have noticed another place where the intellisense list fails to display the table list:
If Exists(Select epPCSDepType From
When this is typed the list is of functions, not tables.
Thanks,
Chris
Bug Displaying Fields When Table Name Is Typed Out and Paren
I have noticed in Query Analyzer that when I type
"Select * from ePe" then select the table name from the list, when I get to the "Where " it pops up a list of fields from that table, as expected.
...
Error When Copying Script
Version 3.1.8.276. I ran a compare between 2 DBs and then selected the text to sync server two with server one. When I right clicked and selected "Copy", I received the following error:
See the end...
126(The specified module could not be found)
I just installed SQL Backup for eval and when I attempted to run the generated extended procedure script (below) I received the following error.
master..sqlbackup '-SQL "BACKUP DATABASE [PSProd] T...