Viewing 15 posts - 61 through 75 (of 118 total)
Run profiler for a while and catch all the active logins.
Or run sp_who2 in frequent intervals and prepare the list of logins used.
Seems silly???:-) is there any other best way...
March 20, 2009 at 12:12 am
Make the id column as identity and start the values from 2 with an increment of 1.Use dbcc checkident reseed to acheive this.
Then import the data from the excel normally...
March 19, 2009 at 11:58 pm
and while restoring the fullbackup use WITH NO RECOVERY and while restoring diff backup use WITH RECOVERY
March 19, 2009 at 2:30 am
Yes .Jones is right...
I've recently done this.Create a login in source server and map the user to the source database.After one hour the user will get updated in stand-by database...
March 18, 2009 at 11:25 pm
Well...login problem is resolved...now its problem from the server-side.
Restart the sql server service once...(if its not production:-))
Check if the protocols(tcp/ip,shared memory) are enabled.
March 18, 2009 at 6:39 am
where exactly you got the error??Paste the error...
March 18, 2009 at 6:30 am
Check server properties if it is in Windows authentication mode....
If so, then change it to mixed-mode authentication.
March 18, 2009 at 6:25 am
DBCC OPENTRAN
with the SPID s you get from this terminate them using
KILL [i]spid[/i]
March 18, 2009 at 6:01 am
Through T-SQL its quite complex...
Create another table say table_test with same structure as your table except the identity property.
Move the data into the table_test using insert into...
Rename the original table...
March 18, 2009 at 5:50 am
oh sorry iam wrong...
if you want to disable the identity for a while
use SET IDENTITY_INSERT ON/OFF
to remove identity property then i suggest wizard.rick click on the table-->modify table
any other ideas...
March 18, 2009 at 5:39 am
ALTER table tablename
ALTER column columnname datatype
through wizard its more easy...
March 18, 2009 at 5:34 am
you declared id as varchar(10).How can you add 1 to it???
March 18, 2009 at 2:10 am
How to run Profiler?
go to performance tools-->sql profiler
open new trace and give the authentication for that server.
leave everything to default and click the "Run".Later stop the trace and search...
March 18, 2009 at 12:50 am
The Issue is that after some times all the Database Tables and Store Procedure are dropped automatically. I don't know what is the problem causing this.
Strange...check if any job is...
March 18, 2009 at 12:22 am
Depends on your requirement...
If the resultsets have same columns then you can join them by UNION.
From performance point of view there's no big impact of returning multiple datasets.
March 17, 2009 at 11:17 pm
Viewing 15 posts - 61 through 75 (of 118 total)