Viewing 15 posts - 1,156 through 1,170 (of 1,199 total)
You can see when a login was created in the catalog view sys.server_principals.
The default trace records events like creating or dropping a login, but keep in mind this information is...
July 11, 2013 at 2:24 am
Filipe (7/10/2013)
I thought that SQL would check for the schema with the same user name, and if that was not available would always default to DBO.
So this is not entirely...
July 11, 2013 at 2:12 am
I would device the import process so that the columns are always there, but if they are not in the spreadsheet they would be NULL.
A table is supposed to model...
July 10, 2013 at 4:19 pm
I've done this with PowerDesigner, but PD is not exactly cheap.
There is a diagram feature in SSMS, altough it's much to get excited over.
July 10, 2013 at 2:27 pm
It helps if you give the context. What do you try to do? Do you need the distributed transaction?
Also, are the two servers in the same domain? In a workgroup?...
July 10, 2013 at 2:26 pm
Are there other applicaitons running on the server? Else I see little reason to see Max Server Memory to 2GB when you have 4GB in the machine. Set it to...
July 10, 2013 at 2:22 pm
deepkt (7/10/2013)
I understood your point, If possible could you share logic using TVP .
I have already given it. When the user is done with the grid, populate the sorter column...
July 10, 2013 at 8:09 am
deepkt (7/10/2013)
Does there any possibility of fine tuning of my procedure to accommodate my requirement, I am stuck with the code.Please help..
We are helping. You are refusing to be helped....
July 10, 2013 at 6:12 am
deepkt (7/10/2013)
In UI I am binding data to a grid.. all the logic will be processed using stored proc and from back end.
In UI user will modify...
July 10, 2013 at 5:33 am
Your function returns 1 if any of the columns exists in the table, not if all columns exists in the table.
But it is not going to work out anyway. If...
July 10, 2013 at 4:07 am
Change your stored procedure to work with input in a table-valued parameter which holds the new sort order for all values. Or at least all values for which the sort...
July 10, 2013 at 4:01 am
Good news! there is an easy way out:
CREATE UNIQUE CLUSTERED INDEX pk_table(pkcol)
WITH (DROP_EXISTING = ON) ON partition_scheme(pkcol)
The key is the DROP_EXISTING = ON clause.
Now, if you plan to...
July 10, 2013 at 3:40 am
You have that information in sys.destination_data_spaces.
July 9, 2013 at 4:17 pm
No, it is not a silly question. But to be sure that you have the very last log backup, you should put the database in single-user mode before you take...
July 9, 2013 at 4:13 pm
mister.magoo (7/8/2013)
This would be because you are attempting...
July 9, 2013 at 2:00 am
Viewing 15 posts - 1,156 through 1,170 (of 1,199 total)