Got this from someone on this site. I cannot take credit for it. I cannot remember who it was... ALTER TABLE TableWithDuplicates ADD EliminateDuplicates_RowID int NOT NULL IDENTITY(1, 1) DELETE FROM t1 FROM TableWithDuplicates t1 JOIN( SELECT EliminateDuplicates_RowID=MAX(EliminateDuplicates_RowID), Field1, Field2, Field3, Field4 FROM TableWithDuplicates GROUP BY Field1, Field2, Field3, Field4 HAVING COUNT(*) >= 2 ) […]
2003-06-11
2003-06-11
1 reads
Thanks. I setup the stored procedure but I cannot find it when I try to setup link from Management Sever Agent Jobs
2003-06-11
Create a stored procedure that does the required data manipulation, then assign the Job to run the stored procedure: "EXEC my_stored_proc [args]"
2003-06-11
That would do it. so you added all the dependencies to one group to make sure they all fail over together? Wes
2003-06-11
I would try changing the startup to be <domain>/SQLUSER. Make sure this connection has rights to the email feature. This would allow you to "log on" and perform the tests. HTH Guarddata-
2003-06-11
quote: ALTER PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the owner of the procedure, and are not transferable. Wouldn't it be sufficient to add the user to db_ddl_admin role on that db's that he needs? Cheers, Frank
2003-06-11
1 reads
Create linked server in local server to the remote server and call the SP using four part naming convention.
2003-06-10
2 reads
Hello Markus, quote: Here you have a script which corrupts the IAM of a table. Note that after running the script the table in question is longer accessible while the database status remains online. thanks, I will try it in the next days! ...and surely come up with follow-up questions Cheers, Frank
2003-06-10
Thanks AW, but.... I don't understand like resolving the problem! I execute the stored procedure in local SQL Server. In the code of the stored procedure, I use (for example), to reference a table: INSERT INTO TABLE_NAME_1 select ....FIELDS_NAME, .... from [SERVER_NAME].[DB_NAME].[dbo].[TABLE_NAME_2] SERVER_NAME is the name of my local SQL Server. Executing the procedure the […]
2003-06-10
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers